What is difference between database owner and user in the users folder who
has db-owner?
Database owner has full access under the database. Also user who has db-
owner has full access under the database.
When both create a table, table owner is dbo.
Thanks in advance,
Do.
--
Message posted via http://www.sqlmonster.com> When both create a table, table owner is dbo.
No. A user who isn't dbo but is db_owner will now have dbo as owner of the object. This is indeed
the major (and possibly only) difference between being dbo and having the db_owner role.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Do Park via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:48a04eefb96840aea85cee6c4fd2f178@.SQLMonster.com...
> What is difference between database owner and user in the users folder who
> has db-owner?
> Database owner has full access under the database. Also user who has db-
> owner has full access under the database.
> When both create a table, table owner is dbo.
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com
Showing posts with label users. Show all posts
Showing posts with label users. Show all posts
Sunday, March 25, 2012
Difference between database owner and user who has db-owner?
What is difference between database owner and user in the users folder who
has db-owner?
Database owner has full access under the database. Also user who has db-
owner has full access under the database.
When both create a table, table owner is dbo.
Thanks in advance,
Do.
Message posted via http://www.droptable.com> When both create a table, table owner is dbo.
No. A user who isn't dbo but is db_owner will now have dbo as owner of the o
bject. This is indeed
the major (and possibly only) difference between being dbo and having the db
_owner role.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Do Park via droptable.com" <forum@.droptable.com> wrote in message
news:48a04eefb96840aea85cee6c4fd2f178@.SQ
droptable.com...
> What is difference between database owner and user in the users folder who
> has db-owner?
> Database owner has full access under the database. Also user who has db-
> owner has full access under the database.
> When both create a table, table owner is dbo.
> Thanks in advance,
> Do.
> --
> Message posted via http://www.droptable.comsql
has db-owner?
Database owner has full access under the database. Also user who has db-
owner has full access under the database.
When both create a table, table owner is dbo.
Thanks in advance,
Do.
Message posted via http://www.droptable.com> When both create a table, table owner is dbo.
No. A user who isn't dbo but is db_owner will now have dbo as owner of the o
bject. This is indeed
the major (and possibly only) difference between being dbo and having the db
_owner role.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Do Park via droptable.com" <forum@.droptable.com> wrote in message
news:48a04eefb96840aea85cee6c4fd2f178@.SQ
droptable.com...
> What is difference between database owner and user in the users folder who
> has db-owner?
> Database owner has full access under the database. Also user who has db-
> owner has full access under the database.
> When both create a table, table owner is dbo.
> Thanks in advance,
> Do.
> --
> Message posted via http://www.droptable.comsql
Difference between database owner and user who has db-owner?
What is difference between database owner and user in the users folder who
has db-owner?
Database owner has full access under the database. Also user who has db-
owner has full access under the database.
When both create a table, table owner is dbo.
Thanks in advance,
Do.
Message posted via http://www.sqlmonster.com
> When both create a table, table owner is dbo.
No. A user who isn't dbo but is db_owner will now have dbo as owner of the object. This is indeed
the major (and possibly only) difference between being dbo and having the db_owner role.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Do Park via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:48a04eefb96840aea85cee6c4fd2f178@.SQLMonster.c om...
> What is difference between database owner and user in the users folder who
> has db-owner?
> Database owner has full access under the database. Also user who has db-
> owner has full access under the database.
> When both create a table, table owner is dbo.
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com
has db-owner?
Database owner has full access under the database. Also user who has db-
owner has full access under the database.
When both create a table, table owner is dbo.
Thanks in advance,
Do.
Message posted via http://www.sqlmonster.com
> When both create a table, table owner is dbo.
No. A user who isn't dbo but is db_owner will now have dbo as owner of the object. This is indeed
the major (and possibly only) difference between being dbo and having the db_owner role.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Do Park via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:48a04eefb96840aea85cee6c4fd2f178@.SQLMonster.c om...
> What is difference between database owner and user in the users folder who
> has db-owner?
> Database owner has full access under the database. Also user who has db-
> owner has full access under the database.
> When both create a table, table owner is dbo.
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com
Thursday, March 22, 2012
Difference between "Database -- > Users" and "Security --> Users"
Hi Team,
In SQL Enterprise Manager, when we expand "Database -->Users", we see the
users there. When we expand "Security --> logins" we see the same users there.
Can you differentiate these two.
Thanks
Santhosh
Logins are the accounts used to connect to the SQL Server, users are the accounts used within individual databases. So it is possible (not very useful, but possible) to have a login so that you can connect to the server but not be able to actually do anything in any databases. Each login must be mapped to a user in each database that the login needs to use.
Permissions in a database are assigned to users not to logins.
You should read up more on users, logins, and permissions in Books Online.
diff. between named pipe & TCP-IP
Hi
Is there any diff. between Named Pipe& TCP-IP protocol from performance
point of view there by I can force all the users connecting to server with
TCP-IP proctocol only .
Regards
Ajay RengunthwarFrom BOL:
Named Pipes vs. TCP/IP Sockets
In a fast local area network (LAN) environment, Transmission Control
Protocol/Internet Protocol (TCP/IP) Sockets and Named Pipes clients are
comparable in terms of performance. However, the performance difference
between the TCP/IP Sockets and Named Pipes clients becomes apparent with
slower networks, such as across wide area networks (WANs) or dial-up
networks. This is because of the different ways the interprocess
communication (IPC) mechanisms communicate between peers.
For named pipes, network communications are typically more interactive. A
peer does not send data until another peer asks for it using a read command.
A network read typically involves a series of peek named pipes messages
before it begins to read the data. These can be very costly in a slow
network and cause excessive network traffic, which in turn affects other
network clients.
It is also important to clarify if you are talking about local pipes or
network pipes. If the server application is running locally on the computer
running an instance of Microsoft® SQL ServerT 2000, the local Named Pipes
protocol is an option. Local named pipes runs in kernel mode and is
extremely fast.
For TCP/IP Sockets, data transmissions are more streamlined and have less
overhead. Data transmissions can also take advantage of TCP/IP Sockets
performance enhancement mechanisms such as windowing, delayed
acknowledgements, and so on, which can be very beneficial in a slow network.
Depending on the type of applications, such performance differences can be
significant.
TCP/IP Sockets also support a backlog queue, which can provide a limited
smoothing effect compared to named pipes that may lead to pipe busy errors
when you are attempting to connect to SQL Server.
In general, sockets are preferred in a slow LAN, WAN, or dial-up network,
whereas named pipes can be a better choice when network speed is not the
issue, as it offers more functionality, ease of use, and configuration
options.
"AJAY R" <dba_pune@.hotmail.com> wrote in message
news:er$fIigRDHA.3132@.tk2msftngp13.phx.gbl...
> Hi
> Is there any diff. between Named Pipe& TCP-IP protocol from performance
> point of view there by I can force all the users connecting to server with
> TCP-IP proctocol only .
> Regards
> Ajay Rengunthwar
>
>
Is there any diff. between Named Pipe& TCP-IP protocol from performance
point of view there by I can force all the users connecting to server with
TCP-IP proctocol only .
Regards
Ajay RengunthwarFrom BOL:
Named Pipes vs. TCP/IP Sockets
In a fast local area network (LAN) environment, Transmission Control
Protocol/Internet Protocol (TCP/IP) Sockets and Named Pipes clients are
comparable in terms of performance. However, the performance difference
between the TCP/IP Sockets and Named Pipes clients becomes apparent with
slower networks, such as across wide area networks (WANs) or dial-up
networks. This is because of the different ways the interprocess
communication (IPC) mechanisms communicate between peers.
For named pipes, network communications are typically more interactive. A
peer does not send data until another peer asks for it using a read command.
A network read typically involves a series of peek named pipes messages
before it begins to read the data. These can be very costly in a slow
network and cause excessive network traffic, which in turn affects other
network clients.
It is also important to clarify if you are talking about local pipes or
network pipes. If the server application is running locally on the computer
running an instance of Microsoft® SQL ServerT 2000, the local Named Pipes
protocol is an option. Local named pipes runs in kernel mode and is
extremely fast.
For TCP/IP Sockets, data transmissions are more streamlined and have less
overhead. Data transmissions can also take advantage of TCP/IP Sockets
performance enhancement mechanisms such as windowing, delayed
acknowledgements, and so on, which can be very beneficial in a slow network.
Depending on the type of applications, such performance differences can be
significant.
TCP/IP Sockets also support a backlog queue, which can provide a limited
smoothing effect compared to named pipes that may lead to pipe busy errors
when you are attempting to connect to SQL Server.
In general, sockets are preferred in a slow LAN, WAN, or dial-up network,
whereas named pipes can be a better choice when network speed is not the
issue, as it offers more functionality, ease of use, and configuration
options.
"AJAY R" <dba_pune@.hotmail.com> wrote in message
news:er$fIigRDHA.3132@.tk2msftngp13.phx.gbl...
> Hi
> Is there any diff. between Named Pipe& TCP-IP protocol from performance
> point of view there by I can force all the users connecting to server with
> TCP-IP proctocol only .
> Regards
> Ajay Rengunthwar
>
>
Wednesday, March 21, 2012
Diff between Logins & Users
Hi ,
What is the diff between Logins & Users in SQL Server?
thanks
Babu
A login is a server principal, create and granted access at the server level. To allow a user access to the database you will have to map him / create a new database principal (You named it user, could also be a Windows security group). Server Principals can also be mapped to Database roles like the sa to dbo which avoid creating a database principal in the database.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Hi,
- The login is to be able to access the SQL Server Instance. Here you will add Windows accounts that can access the server. By default the Administrators group of the pc running the SQL Server Instance is added to the Logins. It is also possible to create SQL Server accounts like the sa account.
- The Users in SQL Server are used to give permissions to database objects like databases/tables/views/... . A user maps to a login.
- The Roles in SQL Server make it easier to give a group of permissions to users in case of setting all these permissions one by one. You have roles on database and on server level. For example the sa account is added to the sysadmin server role meaning that it has full control over everything within that server.
So in order to be able to perform queries on a table you need the following:
a login to connect to the server
Did sqlwish@ go swish?, say it ain't so!
Lets say we start with the release of S2k.For the last
five years users have be encourage to send their
wishes to sqlwish_@.microsoft.com and/or
http://register_.microsoft.com/mswish/suggestion.asp
Now that's gotta be a lot of data.I confess to being a
bonehead because I can't find any summary of this
data anywhere at MS.Can someone please tell me where
I can find the analysis of this data.Certainly,it's not
possible that nothing was done to formalize this data.
This data is important because not only will it be a
measure of how S2005 stacks up to the priorties of the
user base but it will give all of us some insight into
the nature of the users themselves.
So please supply a link and don't let me think it
evaporated into thin air.
You think MS is going to freely share its market analysis with us? I, too,
would love to see this data, but I'm not holding my breath...
But I will point out that absolutely nothing I've requested has made it into
2005. Instead of something useful (DOMAINs!) we get features like PIVOT...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Pike" <stevenospam@.rac4sql.net> wrote in message
news:O8JbpaF7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Lets say we start with the release of S2k.For the last
> five years users have be encourage to send their
> wishes to sqlwish_@.microsoft.com and/or
> http://register_.microsoft.com/mswish/suggestion.asp
> Now that's gotta be a lot of data.I confess to being a
> bonehead because I can't find any summary of this
> data anywhere at MS.Can someone please tell me where
> I can find the analysis of this data.Certainly,it's not
> possible that nothing was done to formalize this data.
> This data is important because not only will it be a
> measure of how S2005 stacks up to the priorties of the
> user base but it will give all of us some insight into
> the nature of the users themselves.
> So please supply a link and don't let me think it
> evaporated into thin air.
>
|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uP8jDrF7EHA.2572@.tk2msftngp13.phx.gbl...
> You think MS is going to freely share its market analysis with us? I,
> too,
> would love to see this data, but I'm not holding my breath...
You'd think they'd like to show how responsive they are to their users.
MS marketing, where art thou?
Perhaps they don't care if some draw some negative opinions
> But I will point out that absolutely nothing I've requested has made it
> into
> 2005.
Maybe for S2010 you'll have more clout
> Instead of something useful (DOMAINs!) we get features like PIVOT...
Funny, PIVOT is one of my favorites
www.rac4sql.net
|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>
> Funny, PIVOT is one of my favorites
Why? What value does it provide over standard SQL cross-tab techniques
or your product? I'm still waiting for a good answer from the SQL Server
team, although I obviously p*ssed a few people off with that question when I
asked in the 2005 newsgroups
|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> www.rac4sql.net
>
By the way, your website doesn't work well with Firefox. Especially this
page:
http://www.rac4sql.com/onlinehelp.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:O$7EBCG7EHA.1396@.tk2msftngp13.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Why? What value does it provide over standard SQL cross-tab techniques
> or your product?
None.Now you know why it's one of my favorites
> I'm still waiting for a good answer from the SQL Server
> team, although I obviously p*ssed a few people off with that question when
> I
> asked in the 2005 newsgroups
Careful, you can go to LVP
Do keep up your good work.
|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:unuVfDG7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> By the way, your website doesn't work well with Firefox. Especially this
> page:
> http://www.rac4sql.com/onlinehelp.asp
Thanks.
five years users have be encourage to send their
wishes to sqlwish_@.microsoft.com and/or
http://register_.microsoft.com/mswish/suggestion.asp
Now that's gotta be a lot of data.I confess to being a
bonehead because I can't find any summary of this
data anywhere at MS.Can someone please tell me where
I can find the analysis of this data.Certainly,it's not
possible that nothing was done to formalize this data.
This data is important because not only will it be a
measure of how S2005 stacks up to the priorties of the
user base but it will give all of us some insight into
the nature of the users themselves.
So please supply a link and don't let me think it
evaporated into thin air.
You think MS is going to freely share its market analysis with us? I, too,
would love to see this data, but I'm not holding my breath...
But I will point out that absolutely nothing I've requested has made it into
2005. Instead of something useful (DOMAINs!) we get features like PIVOT...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Pike" <stevenospam@.rac4sql.net> wrote in message
news:O8JbpaF7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Lets say we start with the release of S2k.For the last
> five years users have be encourage to send their
> wishes to sqlwish_@.microsoft.com and/or
> http://register_.microsoft.com/mswish/suggestion.asp
> Now that's gotta be a lot of data.I confess to being a
> bonehead because I can't find any summary of this
> data anywhere at MS.Can someone please tell me where
> I can find the analysis of this data.Certainly,it's not
> possible that nothing was done to formalize this data.
> This data is important because not only will it be a
> measure of how S2005 stacks up to the priorties of the
> user base but it will give all of us some insight into
> the nature of the users themselves.
> So please supply a link and don't let me think it
> evaporated into thin air.
>
|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uP8jDrF7EHA.2572@.tk2msftngp13.phx.gbl...
> You think MS is going to freely share its market analysis with us? I,
> too,
> would love to see this data, but I'm not holding my breath...
You'd think they'd like to show how responsive they are to their users.
MS marketing, where art thou?
Perhaps they don't care if some draw some negative opinions
> But I will point out that absolutely nothing I've requested has made it
> into
> 2005.
Maybe for S2010 you'll have more clout
> Instead of something useful (DOMAINs!) we get features like PIVOT...
Funny, PIVOT is one of my favorites
www.rac4sql.net
|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>
> Funny, PIVOT is one of my favorites
Why? What value does it provide over standard SQL cross-tab techniques
or your product? I'm still waiting for a good answer from the SQL Server
team, although I obviously p*ssed a few people off with that question when I
asked in the 2005 newsgroups
|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> www.rac4sql.net
>
By the way, your website doesn't work well with Firefox. Especially this
page:
http://www.rac4sql.com/onlinehelp.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:O$7EBCG7EHA.1396@.tk2msftngp13.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Why? What value does it provide over standard SQL cross-tab techniques
> or your product?
None.Now you know why it's one of my favorites
> I'm still waiting for a good answer from the SQL Server
> team, although I obviously p*ssed a few people off with that question when
> I
> asked in the 2005 newsgroups
Careful, you can go to LVP
Do keep up your good work.
|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:unuVfDG7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> By the way, your website doesn't work well with Firefox. Especially this
> page:
> http://www.rac4sql.com/onlinehelp.asp
Thanks.
Monday, March 19, 2012
Did sqlwish@ go swish?, say it ain't so!
Lets say we start with the release of S2k.For the last
five years users have be encourage to send their
wishes to sqlwish_@.microsoft.com and/or
http://register_.microsoft.com/mswish/suggestion.asp
Now that's gotta be a lot of data.I confess to being a
bonehead because I can't find any summary of this
data anywhere at MS.Can someone please tell me where
I can find the analysis of this data.Certainly,it's not
possible that nothing was done to formalize this data.
This data is important because not only will it be a
measure of how S2005 stacks up to the priorties of the
user base but it will give all of us some insight into
the nature of the users themselves.
So please supply a link and don't let me think it
evaporated into thin air.You think MS is going to freely share its market analysis with us? I, too,
would love to see this data, but I'm not holding my breath...
But I will point out that absolutely nothing I've requested has made it into
2005. Instead of something useful (DOMAINs!) we get features like PIVOT...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Pike" <stevenospam@.rac4sql.net> wrote in message
news:O8JbpaF7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Lets say we start with the release of S2k.For the last
> five years users have be encourage to send their
> wishes to sqlwish_@.microsoft.com and/or
> http://register_.microsoft.com/mswish/suggestion.asp
> Now that's gotta be a lot of data.I confess to being a
> bonehead because I can't find any summary of this
> data anywhere at MS.Can someone please tell me where
> I can find the analysis of this data.Certainly,it's not
> possible that nothing was done to formalize this data.
> This data is important because not only will it be a
> measure of how S2005 stacks up to the priorties of the
> user base but it will give all of us some insight into
> the nature of the users themselves.
> So please supply a link and don't let me think it
> evaporated into thin air.
>|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uP8jDrF7EHA.2572@.tk2msftngp13.phx.gbl...
> You think MS is going to freely share its market analysis with us? I,
> too,
> would love to see this data, but I'm not holding my breath...
You'd think they'd like to show how responsive they are to their users.
MS marketing, where art thou?
Perhaps they don't care if some draw some negative opinions
> But I will point out that absolutely nothing I've requested has made it
> into
> 2005.
Maybe for S2010 you'll have more clout
> Instead of something useful (DOMAINs!) we get features like PIVOT...
Funny, PIVOT is one of my favorites
www.rac4sql.net|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>
> Funny, PIVOT is one of my favorites
Why? What value does it provide over standard SQL cross-tab techniques
or your product? I'm still waiting for a good answer from the SQL Server
team, although I obviously p*ssed a few people off with that question when I
asked in the 2005 newsgroups|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> www.rac4sql.net
>
By the way, your website doesn't work well with Firefox. Especially this
page:
http://www.rac4sql.com/onlinehelp.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:O$7EBCG7EHA.1396@.tk2msftngp13.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Why? What value does it provide over standard SQL cross-tab techniques
> or your product?
None.Now you know why it's one of my favorites
> I'm still waiting for a good answer from the SQL Server
> team, although I obviously p*ssed a few people off with that question when
> I
> asked in the 2005 newsgroups
Careful, you can go to LVP
Do keep up your good work.|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:unuVfDG7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> By the way, your website doesn't work well with Firefox. Especially this
> page:
> http://www.rac4sql.com/onlinehelp.asp
Thanks.
five years users have be encourage to send their
wishes to sqlwish_@.microsoft.com and/or
http://register_.microsoft.com/mswish/suggestion.asp
Now that's gotta be a lot of data.I confess to being a
bonehead because I can't find any summary of this
data anywhere at MS.Can someone please tell me where
I can find the analysis of this data.Certainly,it's not
possible that nothing was done to formalize this data.
This data is important because not only will it be a
measure of how S2005 stacks up to the priorties of the
user base but it will give all of us some insight into
the nature of the users themselves.
So please supply a link and don't let me think it
evaporated into thin air.You think MS is going to freely share its market analysis with us? I, too,
would love to see this data, but I'm not holding my breath...
But I will point out that absolutely nothing I've requested has made it into
2005. Instead of something useful (DOMAINs!) we get features like PIVOT...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Pike" <stevenospam@.rac4sql.net> wrote in message
news:O8JbpaF7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Lets say we start with the release of S2k.For the last
> five years users have be encourage to send their
> wishes to sqlwish_@.microsoft.com and/or
> http://register_.microsoft.com/mswish/suggestion.asp
> Now that's gotta be a lot of data.I confess to being a
> bonehead because I can't find any summary of this
> data anywhere at MS.Can someone please tell me where
> I can find the analysis of this data.Certainly,it's not
> possible that nothing was done to formalize this data.
> This data is important because not only will it be a
> measure of how S2005 stacks up to the priorties of the
> user base but it will give all of us some insight into
> the nature of the users themselves.
> So please supply a link and don't let me think it
> evaporated into thin air.
>|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uP8jDrF7EHA.2572@.tk2msftngp13.phx.gbl...
> You think MS is going to freely share its market analysis with us? I,
> too,
> would love to see this data, but I'm not holding my breath...
You'd think they'd like to show how responsive they are to their users.
MS marketing, where art thou?
Perhaps they don't care if some draw some negative opinions
> But I will point out that absolutely nothing I've requested has made it
> into
> 2005.
Maybe for S2010 you'll have more clout
> Instead of something useful (DOMAINs!) we get features like PIVOT...
Funny, PIVOT is one of my favorites
www.rac4sql.net|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>
> Funny, PIVOT is one of my favorites
Why? What value does it provide over standard SQL cross-tab techniques
or your product? I'm still waiting for a good answer from the SQL Server
team, although I obviously p*ssed a few people off with that question when I
asked in the 2005 newsgroups
|||"Pike" <stevenospam@.rac4sql.net> wrote in messagenews:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> www.rac4sql.net
>
By the way, your website doesn't work well with Firefox. Especially this
page:
http://www.rac4sql.com/onlinehelp.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:O$7EBCG7EHA.1396@.tk2msftngp13.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Why? What value does it provide over standard SQL cross-tab techniques
> or your product?
None.Now you know why it's one of my favorites
> I'm still waiting for a good answer from the SQL Server
> team, although I obviously p*ssed a few people off with that question when
> I
> asked in the 2005 newsgroups
Careful, you can go to LVP
Do keep up your good work.|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:unuVfDG7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> By the way, your website doesn't work well with Firefox. Especially this
> page:
> http://www.rac4sql.com/onlinehelp.asp
Thanks.
Did sqlwish@ go swish?, say it ain't so!
Lets say we start with the release of S2k.For the last
five years users have be encourage to send their
wishes to sqlwish_@.microsoft.com and/or
http://register_.microsoft.com/mswish/suggestion.asp
Now that's gotta be a lot of data.I confess to being a
bonehead because I can't find any summary of this
data anywhere at MS.Can someone please tell me where
I can find the analysis of this data.Certainly,it's not
possible that nothing was done to formalize this data.
This data is important because not only will it be a
measure of how S2005 stacks up to the priorties of the
user base but it will give all of us some insight into
the nature of the users themselves.
So please supply a link and don't let me think it
evaporated into thin air.You think MS is going to freely share its market analysis with us? I, too,
would love to see this data, but I'm not holding my breath...
But I will point out that absolutely nothing I've requested has made it into
2005. Instead of something useful (DOMAINs!) we get features like PIVOT...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Pike" <stevenospam@.rac4sql.net> wrote in message
news:O8JbpaF7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Lets say we start with the release of S2k.For the last
> five years users have be encourage to send their
> wishes to sqlwish_@.microsoft.com and/or
> http://register_.microsoft.com/mswish/suggestion.asp
> Now that's gotta be a lot of data.I confess to being a
> bonehead because I can't find any summary of this
> data anywhere at MS.Can someone please tell me where
> I can find the analysis of this data.Certainly,it's not
> possible that nothing was done to formalize this data.
> This data is important because not only will it be a
> measure of how S2005 stacks up to the priorties of the
> user base but it will give all of us some insight into
> the nature of the users themselves.
> So please supply a link and don't let me think it
> evaporated into thin air.
>|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uP8jDrF7EHA.2572@.tk2msftngp13.phx.gbl...
> You think MS is going to freely share its market analysis with us? I,
> too,
> would love to see this data, but I'm not holding my breath...
You'd think they'd like to show how responsive they are to their users.
MS marketing, where art thou?
Perhaps they don't care if some draw some negative opinions:)
> But I will point out that absolutely nothing I've requested has made it
> into
> 2005.
Maybe for S2010 you'll have more clout:)
> Instead of something useful (DOMAINs!) we get features like PIVOT...
Funny, PIVOT is one of my favorites:)
www.rac4sql.net|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>
> Funny, PIVOT is one of my favorites:)
Why? What value does it provide over standard SQL cross-tab techniques
or your product? I'm still waiting for a good answer from the SQL Server
team, although I obviously p*ssed a few people off with that question when I
asked in the 2005 newsgroups :)|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> www.rac4sql.net
>
By the way, your website doesn't work well with Firefox. Especially this
page:
http://www.rac4sql.com/onlinehelp.asp
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:O$7EBCG7EHA.1396@.tk2msftngp13.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>>
>> Funny, PIVOT is one of my favorites:)
> Why? What value does it provide over standard SQL cross-tab techniques
> or your product?
None.Now you know why it's one of my favorites:)
> I'm still waiting for a good answer from the SQL Server
> team, although I obviously p*ssed a few people off with that question when
> I
> asked in the 2005 newsgroups :)
Careful, you can go to LVP:)
Do keep up your good work.|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:unuVfDG7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>> www.rac4sql.net
> By the way, your website doesn't work well with Firefox. Especially this
> page:
> http://www.rac4sql.com/onlinehelp.asp
Thanks.
five years users have be encourage to send their
wishes to sqlwish_@.microsoft.com and/or
http://register_.microsoft.com/mswish/suggestion.asp
Now that's gotta be a lot of data.I confess to being a
bonehead because I can't find any summary of this
data anywhere at MS.Can someone please tell me where
I can find the analysis of this data.Certainly,it's not
possible that nothing was done to formalize this data.
This data is important because not only will it be a
measure of how S2005 stacks up to the priorties of the
user base but it will give all of us some insight into
the nature of the users themselves.
So please supply a link and don't let me think it
evaporated into thin air.You think MS is going to freely share its market analysis with us? I, too,
would love to see this data, but I'm not holding my breath...
But I will point out that absolutely nothing I've requested has made it into
2005. Instead of something useful (DOMAINs!) we get features like PIVOT...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Pike" <stevenospam@.rac4sql.net> wrote in message
news:O8JbpaF7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Lets say we start with the release of S2k.For the last
> five years users have be encourage to send their
> wishes to sqlwish_@.microsoft.com and/or
> http://register_.microsoft.com/mswish/suggestion.asp
> Now that's gotta be a lot of data.I confess to being a
> bonehead because I can't find any summary of this
> data anywhere at MS.Can someone please tell me where
> I can find the analysis of this data.Certainly,it's not
> possible that nothing was done to formalize this data.
> This data is important because not only will it be a
> measure of how S2005 stacks up to the priorties of the
> user base but it will give all of us some insight into
> the nature of the users themselves.
> So please supply a link and don't let me think it
> evaporated into thin air.
>|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uP8jDrF7EHA.2572@.tk2msftngp13.phx.gbl...
> You think MS is going to freely share its market analysis with us? I,
> too,
> would love to see this data, but I'm not holding my breath...
You'd think they'd like to show how responsive they are to their users.
MS marketing, where art thou?
Perhaps they don't care if some draw some negative opinions:)
> But I will point out that absolutely nothing I've requested has made it
> into
> 2005.
Maybe for S2010 you'll have more clout:)
> Instead of something useful (DOMAINs!) we get features like PIVOT...
Funny, PIVOT is one of my favorites:)
www.rac4sql.net|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>
> Funny, PIVOT is one of my favorites:)
Why? What value does it provide over standard SQL cross-tab techniques
or your product? I'm still waiting for a good answer from the SQL Server
team, although I obviously p*ssed a few people off with that question when I
asked in the 2005 newsgroups :)|||"Pike" <stevenospam@.rac4sql.net> wrote in message
news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> www.rac4sql.net
>
By the way, your website doesn't work well with Firefox. Especially this
page:
http://www.rac4sql.com/onlinehelp.asp
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:O$7EBCG7EHA.1396@.tk2msftngp13.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>>
>> Funny, PIVOT is one of my favorites:)
> Why? What value does it provide over standard SQL cross-tab techniques
> or your product?
None.Now you know why it's one of my favorites:)
> I'm still waiting for a good answer from the SQL Server
> team, although I obviously p*ssed a few people off with that question when
> I
> asked in the 2005 newsgroups :)
Careful, you can go to LVP:)
Do keep up your good work.|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:unuVfDG7EHA.1452@.TK2MSFTNGP11.phx.gbl...
> "Pike" <stevenospam@.rac4sql.net> wrote in message
> news:u97mS$F7EHA.1452@.TK2MSFTNGP11.phx.gbl...
>> www.rac4sql.net
> By the way, your website doesn't work well with Firefox. Especially this
> page:
> http://www.rac4sql.com/onlinehelp.asp
Thanks.
Friday, February 24, 2012
Developer Edition Restrictions
Are there any restrictions on the Developer Edition of SQL Server 2000? I
am aware that you are allowed only 2 users in at the same time, but are
there other restrictions, like restrictions on the # of concurrent
transactions, or anything else like that? Or is it fully functional,
exactly the same as a regular version, other than the user limitation? I
have it installed on my development machine, and I'm using ASP to develop a
web application, and just wondered if this would be sufficient for running
a web application where potentially 25 or 30 users could be on the web site
at the same time (all using the same user name to connect, so it doesn't
violate the user limit).
Just wondering.
Thanks,
Jesse
"Jesse" <nospam@.fake.com> wrote in message
news:unrELl3OFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Are there any restrictions on the Developer Edition of SQL Server 2000? I
> am aware that you are allowed only 2 users in at the same time, but are
> there other restrictions, like restrictions on the # of concurrent
> transactions, or anything else like that? Or is it fully functional,
> exactly the same as a regular version, other than the user limitation? I
> have it installed on my development machine, and I'm using ASP to develop
> a web application, and just wondered if this would be sufficient for
> running a web application where potentially 25 or 30 users could be on the
> web site at the same time (all using the same user name to connect, so it
> doesn't violate the user limit).
>
There are no functional limitations on Developer Edition. It runs exactly
like Enterprise Edition.
The limitations are only in the license, which is here:
http://www.microsoft.com/sql/howtobuy/development.asp
There is no limit on the number of clients who can connect, but they can
only connect in conjunction with "designing, developing and testing" your
application. So you can test your application with 5000 users. But you
can't run it in production at all.
David
am aware that you are allowed only 2 users in at the same time, but are
there other restrictions, like restrictions on the # of concurrent
transactions, or anything else like that? Or is it fully functional,
exactly the same as a regular version, other than the user limitation? I
have it installed on my development machine, and I'm using ASP to develop a
web application, and just wondered if this would be sufficient for running
a web application where potentially 25 or 30 users could be on the web site
at the same time (all using the same user name to connect, so it doesn't
violate the user limit).
Just wondering.
Thanks,
Jesse
"Jesse" <nospam@.fake.com> wrote in message
news:unrELl3OFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Are there any restrictions on the Developer Edition of SQL Server 2000? I
> am aware that you are allowed only 2 users in at the same time, but are
> there other restrictions, like restrictions on the # of concurrent
> transactions, or anything else like that? Or is it fully functional,
> exactly the same as a regular version, other than the user limitation? I
> have it installed on my development machine, and I'm using ASP to develop
> a web application, and just wondered if this would be sufficient for
> running a web application where potentially 25 or 30 users could be on the
> web site at the same time (all using the same user name to connect, so it
> doesn't violate the user limit).
>
There are no functional limitations on Developer Edition. It runs exactly
like Enterprise Edition.
The limitations are only in the license, which is here:
http://www.microsoft.com/sql/howtobuy/development.asp
There is no limit on the number of clients who can connect, but they can
only connect in conjunction with "designing, developing and testing" your
application. So you can test your application with 5000 users. But you
can't run it in production at all.
David
Developer Edition Restrictions
Are there any restrictions on the Developer Edition of SQL Server 2000? I
am aware that you are allowed only 2 users in at the same time, but are
there other restrictions, like restrictions on the # of concurrent
transactions, or anything else like that? Or is it fully functional,
exactly the same as a regular version, other than the user limitation? I
have it installed on my development machine, and I'm using ASP to develop a
web application, and just wondered if this would be sufficient for running
a web application where potentially 25 or 30 users could be on the web site
at the same time (all using the same user name to connect, so it doesn't
violate the user limit).
Just wondering.
Thanks,
Jesse"Jesse" <nospam@.fake.com> wrote in message
news:unrELl3OFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Are there any restrictions on the Developer Edition of SQL Server 2000? I
> am aware that you are allowed only 2 users in at the same time, but are
> there other restrictions, like restrictions on the # of concurrent
> transactions, or anything else like that? Or is it fully functional,
> exactly the same as a regular version, other than the user limitation? I
> have it installed on my development machine, and I'm using ASP to develop
> a web application, and just wondered if this would be sufficient for
> running a web application where potentially 25 or 30 users could be on the
> web site at the same time (all using the same user name to connect, so it
> doesn't violate the user limit).
>
There are no functional limitations on Developer Edition. It runs exactly
like Enterprise Edition.
The limitations are only in the license, which is here:
http://www.microsoft.com/sql/howtobuy/development.asp
There is no limit on the number of clients who can connect, but they can
only connect in conjunction with "designing, developing and testing" your
application. So you can test your application with 5000 users. But you
can't run it in production at all.
David
am aware that you are allowed only 2 users in at the same time, but are
there other restrictions, like restrictions on the # of concurrent
transactions, or anything else like that? Or is it fully functional,
exactly the same as a regular version, other than the user limitation? I
have it installed on my development machine, and I'm using ASP to develop a
web application, and just wondered if this would be sufficient for running
a web application where potentially 25 or 30 users could be on the web site
at the same time (all using the same user name to connect, so it doesn't
violate the user limit).
Just wondering.
Thanks,
Jesse"Jesse" <nospam@.fake.com> wrote in message
news:unrELl3OFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Are there any restrictions on the Developer Edition of SQL Server 2000? I
> am aware that you are allowed only 2 users in at the same time, but are
> there other restrictions, like restrictions on the # of concurrent
> transactions, or anything else like that? Or is it fully functional,
> exactly the same as a regular version, other than the user limitation? I
> have it installed on my development machine, and I'm using ASP to develop
> a web application, and just wondered if this would be sufficient for
> running a web application where potentially 25 or 30 users could be on the
> web site at the same time (all using the same user name to connect, so it
> doesn't violate the user limit).
>
There are no functional limitations on Developer Edition. It runs exactly
like Enterprise Edition.
The limitations are only in the license, which is here:
http://www.microsoft.com/sql/howtobuy/development.asp
There is no limit on the number of clients who can connect, but they can
only connect in conjunction with "designing, developing and testing" your
application. So you can test your application with 5000 users. But you
can't run it in production at all.
David
Developer Edition Restrictions
Are there any restrictions on the Developer Edition of SQL Server 2000? I
am aware that you are allowed only 2 users in at the same time, but are
there other restrictions, like restrictions on the # of concurrent
transactions, or anything else like that? Or is it fully functional,
exactly the same as a regular version, other than the user limitation? I
have it installed on my development machine, and I'm using ASP to develop a
web application, and just wondered if this would be sufficient for running
a web application where potentially 25 or 30 users could be on the web site
at the same time (all using the same user name to connect, so it doesn't
violate the user limit).
Just wondering.
Thanks,
Jesse"Jesse" <nospam@.fake.com> wrote in message
news:unrELl3OFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Are there any restrictions on the Developer Edition of SQL Server 2000? I
> am aware that you are allowed only 2 users in at the same time, but are
> there other restrictions, like restrictions on the # of concurrent
> transactions, or anything else like that? Or is it fully functional,
> exactly the same as a regular version, other than the user limitation? I
> have it installed on my development machine, and I'm using ASP to develop
> a web application, and just wondered if this would be sufficient for
> running a web application where potentially 25 or 30 users could be on the
> web site at the same time (all using the same user name to connect, so it
> doesn't violate the user limit).
>
There are no functional limitations on Developer Edition. It runs exactly
like Enterprise Edition.
The limitations are only in the license, which is here:
http://www.microsoft.com/sql/howtobuy/development.asp
There is no limit on the number of clients who can connect, but they can
only connect in conjunction with "designing, developing and testing" your
application. So you can test your application with 5000 users. But you
can't run it in production at all.
David
am aware that you are allowed only 2 users in at the same time, but are
there other restrictions, like restrictions on the # of concurrent
transactions, or anything else like that? Or is it fully functional,
exactly the same as a regular version, other than the user limitation? I
have it installed on my development machine, and I'm using ASP to develop a
web application, and just wondered if this would be sufficient for running
a web application where potentially 25 or 30 users could be on the web site
at the same time (all using the same user name to connect, so it doesn't
violate the user limit).
Just wondering.
Thanks,
Jesse"Jesse" <nospam@.fake.com> wrote in message
news:unrELl3OFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Are there any restrictions on the Developer Edition of SQL Server 2000? I
> am aware that you are allowed only 2 users in at the same time, but are
> there other restrictions, like restrictions on the # of concurrent
> transactions, or anything else like that? Or is it fully functional,
> exactly the same as a regular version, other than the user limitation? I
> have it installed on my development machine, and I'm using ASP to develop
> a web application, and just wondered if this would be sufficient for
> running a web application where potentially 25 or 30 users could be on the
> web site at the same time (all using the same user name to connect, so it
> doesn't violate the user limit).
>
There are no functional limitations on Developer Edition. It runs exactly
like Enterprise Edition.
The limitations are only in the license, which is here:
http://www.microsoft.com/sql/howtobuy/development.asp
There is no limit on the number of clients who can connect, but they can
only connect in conjunction with "designing, developing and testing" your
application. So you can test your application with 5000 users. But you
can't run it in production at all.
David
Friday, February 17, 2012
determining who is logged into database server
Hi,
There used to be a command in mssql 6.5 that would tell
return the login names of users who had the database open,
ie, they were still in the app that connects to the db. I
think the command was something like @.@.who. Is there and
equivalent command in SQL 7 and 2k?
Also, is it possible to run sql 6.5 on a win2k server? It
keeps telling me the app is not loaded when I try to run
the service pack.
Thanks,
MikeI think you are looking for the system stored procedures
sp_who and sp_who2.
-Sue
On Mon, 3 Nov 2003 18:29:51 -0800, "Mike Stefani"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>There used to be a command in mssql 6.5 that would tell
>return the login names of users who had the database open,
>ie, they were still in the app that connects to the db. I
>think the command was something like @.@.who. Is there and
>equivalent command in SQL 7 and 2k?
>Also, is it possible to run sql 6.5 on a win2k server? It
>keeps telling me the app is not loaded when I try to run
>the service pack.
>Thanks,
>Mike|||Hi,
I think you are referring to SP_WHO system stored procedure. You can use the
same procedure in SQL 7.0 and SQL 2k from Query analyzer to identify
all the current processes (Users) connected to SQL server.
You can defenetely run SQL 6.5 is Win2k server , but as you said there is
lots of problems. Microsoft recommends not to run SQL 6.5 in Win2k.
Thanks
Hari
MCDBA
"Mike Stefani" <anonymous@.discussions.microsoft.com> wrote in message
news:0b1a01c3a27b$862eff90$a101280a@.phx.gbl...
> Hi,
> There used to be a command in mssql 6.5 that would tell
> return the login names of users who had the database open,
> ie, they were still in the app that connects to the db. I
> think the command was something like @.@.who. Is there and
> equivalent command in SQL 7 and 2k?
> Also, is it possible to run sql 6.5 on a win2k server? It
> keeps telling me the app is not loaded when I try to run
> the service pack.
> Thanks,
> Mike|||its sp_who
--
Shaju Thomas
"Mike Stefani" <anonymous@.discussions.microsoft.com> wrote in message
news:0b1a01c3a27b$862eff90$a101280a@.phx.gbl...
> Hi,
> There used to be a command in mssql 6.5 that would tell
> return the login names of users who had the database open,
> ie, they were still in the app that connects to the db. I
> think the command was something like @.@.who. Is there and
> equivalent command in SQL 7 and 2k?
> Also, is it possible to run sql 6.5 on a win2k server? It
> keeps telling me the app is not loaded when I try to run
> the service pack.
> Thanks,
> Mike
There used to be a command in mssql 6.5 that would tell
return the login names of users who had the database open,
ie, they were still in the app that connects to the db. I
think the command was something like @.@.who. Is there and
equivalent command in SQL 7 and 2k?
Also, is it possible to run sql 6.5 on a win2k server? It
keeps telling me the app is not loaded when I try to run
the service pack.
Thanks,
MikeI think you are looking for the system stored procedures
sp_who and sp_who2.
-Sue
On Mon, 3 Nov 2003 18:29:51 -0800, "Mike Stefani"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>There used to be a command in mssql 6.5 that would tell
>return the login names of users who had the database open,
>ie, they were still in the app that connects to the db. I
>think the command was something like @.@.who. Is there and
>equivalent command in SQL 7 and 2k?
>Also, is it possible to run sql 6.5 on a win2k server? It
>keeps telling me the app is not loaded when I try to run
>the service pack.
>Thanks,
>Mike|||Hi,
I think you are referring to SP_WHO system stored procedure. You can use the
same procedure in SQL 7.0 and SQL 2k from Query analyzer to identify
all the current processes (Users) connected to SQL server.
You can defenetely run SQL 6.5 is Win2k server , but as you said there is
lots of problems. Microsoft recommends not to run SQL 6.5 in Win2k.
Thanks
Hari
MCDBA
"Mike Stefani" <anonymous@.discussions.microsoft.com> wrote in message
news:0b1a01c3a27b$862eff90$a101280a@.phx.gbl...
> Hi,
> There used to be a command in mssql 6.5 that would tell
> return the login names of users who had the database open,
> ie, they were still in the app that connects to the db. I
> think the command was something like @.@.who. Is there and
> equivalent command in SQL 7 and 2k?
> Also, is it possible to run sql 6.5 on a win2k server? It
> keeps telling me the app is not loaded when I try to run
> the service pack.
> Thanks,
> Mike|||its sp_who
--
Shaju Thomas
"Mike Stefani" <anonymous@.discussions.microsoft.com> wrote in message
news:0b1a01c3a27b$862eff90$a101280a@.phx.gbl...
> Hi,
> There used to be a command in mssql 6.5 that would tell
> return the login names of users who had the database open,
> ie, they were still in the app that connects to the db. I
> think the command was something like @.@.who. Is there and
> equivalent command in SQL 7 and 2k?
> Also, is it possible to run sql 6.5 on a win2k server? It
> keeps telling me the app is not loaded when I try to run
> the service pack.
> Thanks,
> Mike
Tuesday, February 14, 2012
Determining Users permissions
While it is possible and easy to answer the question:
"Which Users Have permissions on This Table?" by right-clicking the table,
choosing properties from the menu, then Permissions from the dialog.
Is it possible to answer the question:
"What Permissions does This user have?"
Right-clicking the user and choosing properties lets us choose a tab
"Securables" which is always empty. we can see Server Roles, but not
permissions.
We are using Active Directory Groups to group users into permission-roles.
We cannot use Schemas because a lot of our users use MS Access data projects
to view their data.
There doesn't seem to be any way to determine what permissions a User has,
from the user point of view.
I'm sure we could do this withthe Server 2000 Enterprise Manager, but not
with the new 2005 Management Studio.Hi
IF PERMISSIONS()&2=2
CREATE TABLE test_table (col1 INT)
ELSE
PRINT 'ERROR: The current user cannot create a table.'
--
This example determines whether the current user can
grant the INSERT permission on the authors table to another user.
IF PERMISSIONS(OBJECT_ID('authors'))&0x80000=0x80000
PRINT 'INSERT on authors is grantable.'
ELSE
PRINT 'You may not GRANT INSERT permissions on authors.'
--http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlr
ef/ts_pa-pz_6f78.asp>
How can I retrieve a list of objects and permissions for a specified role?
----
--
In SQL Server 2005, you can use the Has_Perms_By_Name() function
(http://msdn2.microsoft.com/en-us/library/ms189802.aspx).
> For example, I would like to list all stored procedures which a role has
> execute permission for.
This is an example of usage:
SELECT o.SchemaAndName,
has_perms_by_name(o.SchemaAndName, 'OBJECT', 'EXECUTE')
FROM (SELECT name, SCHEMA_NAME(schema_id) AS [schema],
SCHEMA_NAME(schema_id)+'.'+name AS SchemaAndName
FROM sys.objects
WHERE type = 'P') AS o
"BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
news:D130E054-26BD-4AB2-85BE-F4153BB7E7DD@.microsoft.com...
> While it is possible and easy to answer the question:
> "Which Users Have permissions on This Table?" by right-clicking the table,
> choosing properties from the menu, then Permissions from the dialog.
> Is it possible to answer the question:
> "What Permissions does This user have?"
> Right-clicking the user and choosing properties lets us choose a tab
> "Securables" which is always empty. we can see Server Roles, but not
> permissions.
> We are using Active Directory Groups to group users into permission-roles.
> We cannot use Schemas because a lot of our users use MS Access data
> projects
> to view their data.
> There doesn't seem to be any way to determine what permissions a User has,
> from the user point of view.
> I'm sure we could do this withthe Server 2000 Enterprise Manager, but not
> with the new 2005 Management Studio.
>|||Ok, thats all very well for coders, but for example, in Enterprise Manager,
if someone asks me "What permissions on the database does Joe Bloggs in
Accounts have?" I just look up Joe Blogs login, right-click and choose Manag
e
Permissions. I check the box for only showing permissions explicitly defined
and there it is.
I can't DO that in Management studio.
I had a quick look through the functions in master, but the permissions ones
just seem to be concerned with the *current* user. I can see the value of
these... do the test, and if the can, then do the action.
But for a harrased admin being asked the above question... what can be done?
I don't mind cobbling up soem T-SQL to return the perms if required, but it
must be able to be run for any login, not jsut the current one.
BAzz
"Uri Dimant" wrote:
> Hi
> IF PERMISSIONS()&2=2
> CREATE TABLE test_table (col1 INT)
> ELSE
> PRINT 'ERROR: The current user cannot create a table.'
> --
> This example determines whether the current user can
> grant the INSERT permission on the authors table to another user.
> IF PERMISSIONS(OBJECT_ID('authors'))&0x80000=0x80000
> PRINT 'INSERT on authors is grantable.'
> ELSE
> PRINT 'You may not GRANT INSERT permissions on authors.'
> --http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsq
lref/ts_pa-pz_6f78.asp>
> How can I retrieve a list of objects and permissions for a specified role
?
> ----
--
> In SQL Server 2005, you can use the Has_Perms_By_Name() function
> (http://msdn2.microsoft.com/en-us/library/ms189802.aspx).
>
> This is an example of usage:
> SELECT o.SchemaAndName,
> has_perms_by_name(o.SchemaAndName, 'OBJECT', 'EXECUTE')
> FROM (SELECT name, SCHEMA_NAME(schema_id) AS [schema],
> SCHEMA_NAME(schema_id)+'.'+name AS SchemaAndName
> FROM sys.objects
> WHERE type = 'P') AS o
>
>
>
>
> "BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
> news:D130E054-26BD-4AB2-85BE-F4153BB7E7DD@.microsoft.com...
>
>|||BAzz,
Assuming that you are a system administrator for the SQL Server, you can
execute in the context of the login that you are checking. Here is a
sample:
EXECUTE AS login='MYDOMAIN\MyLogin'
SELECT name, is_member(name) FROM sys.database_principals
WHERE is_member (name) = 1
SELECT name, (permissions(object_id)) FROM sys.objects
WHERE permissions(object_id) > 0
REVERT
FWIW, RLF
"BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
news:A8D05A43-38F5-4461-8334-06B8D4FBDC99@.microsoft.com...[vbcol=seagreen]
> Ok, thats all very well for coders, but for example, in Enterprise
> Manager,
> if someone asks me "What permissions on the database does Joe Bloggs in
> Accounts have?" I just look up Joe Blogs login, right-click and choose
> Manage
> Permissions. I check the box for only showing permissions explicitly
> defined
> and there it is.
> I can't DO that in Management studio.
> I had a quick look through the functions in master, but the permissions
> ones
> just seem to be concerned with the *current* user. I can see the value of
> these... do the test, and if the can, then do the action.
> But for a harrased admin being asked the above question... what can be
> done?
> I don't mind cobbling up soem T-SQL to return the perms if required, but
> it
> must be able to be run for any login, not jsut the current one.
> BAzz
>
> "Uri Dimant" wrote:
>|||Thats a great help, thanks. the Execute as... will do the trick in a
parameterised stored proc that I can have return a formatted list of perms..
Makes me wonder, though, why the functionality was removed from the 2005
Management studio.
"Russell Fields" wrote:
> BAzz,
> Assuming that you are a system administrator for the SQL Server, you can
> execute in the context of the login that you are checking. Here is a
> sample:
> EXECUTE AS login='MYDOMAIN\MyLogin'
> SELECT name, is_member(name) FROM sys.database_principals
> WHERE is_member (name) = 1
> SELECT name, (permissions(object_id)) FROM sys.objects
> WHERE permissions(object_id) > 0
> REVERT
> FWIW, RLF
>
> "BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
> news:A8D05A43-38F5-4461-8334-06B8D4FBDC99@.microsoft.com...
>
>|||FWIW, I wonder, too. The current Studio behavior is not helpful to me
either.
RLF
"BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
news:0FF6C000-6010-4119-B1DB-E84047507080@.microsoft.com...[vbcol=seagreen]
> Thats a great help, thanks. the Execute as... will do the trick in a
> parameterised stored proc that I can have return a formatted list of
> perms..
> Makes me wonder, though, why the functionality was removed from the 2005
> Management studio.
>
> "Russell Fields" wrote:
>
"Which Users Have permissions on This Table?" by right-clicking the table,
choosing properties from the menu, then Permissions from the dialog.
Is it possible to answer the question:
"What Permissions does This user have?"
Right-clicking the user and choosing properties lets us choose a tab
"Securables" which is always empty. we can see Server Roles, but not
permissions.
We are using Active Directory Groups to group users into permission-roles.
We cannot use Schemas because a lot of our users use MS Access data projects
to view their data.
There doesn't seem to be any way to determine what permissions a User has,
from the user point of view.
I'm sure we could do this withthe Server 2000 Enterprise Manager, but not
with the new 2005 Management Studio.Hi
IF PERMISSIONS()&2=2
CREATE TABLE test_table (col1 INT)
ELSE
PRINT 'ERROR: The current user cannot create a table.'
--
This example determines whether the current user can
grant the INSERT permission on the authors table to another user.
IF PERMISSIONS(OBJECT_ID('authors'))&0x80000=0x80000
PRINT 'INSERT on authors is grantable.'
ELSE
PRINT 'You may not GRANT INSERT permissions on authors.'
--http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlr
ef/ts_pa-pz_6f78.asp>
How can I retrieve a list of objects and permissions for a specified role?
----
--
In SQL Server 2005, you can use the Has_Perms_By_Name() function
(http://msdn2.microsoft.com/en-us/library/ms189802.aspx).
> For example, I would like to list all stored procedures which a role has
> execute permission for.
This is an example of usage:
SELECT o.SchemaAndName,
has_perms_by_name(o.SchemaAndName, 'OBJECT', 'EXECUTE')
FROM (SELECT name, SCHEMA_NAME(schema_id) AS [schema],
SCHEMA_NAME(schema_id)+'.'+name AS SchemaAndName
FROM sys.objects
WHERE type = 'P') AS o
"BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
news:D130E054-26BD-4AB2-85BE-F4153BB7E7DD@.microsoft.com...
> While it is possible and easy to answer the question:
> "Which Users Have permissions on This Table?" by right-clicking the table,
> choosing properties from the menu, then Permissions from the dialog.
> Is it possible to answer the question:
> "What Permissions does This user have?"
> Right-clicking the user and choosing properties lets us choose a tab
> "Securables" which is always empty. we can see Server Roles, but not
> permissions.
> We are using Active Directory Groups to group users into permission-roles.
> We cannot use Schemas because a lot of our users use MS Access data
> projects
> to view their data.
> There doesn't seem to be any way to determine what permissions a User has,
> from the user point of view.
> I'm sure we could do this withthe Server 2000 Enterprise Manager, but not
> with the new 2005 Management Studio.
>|||Ok, thats all very well for coders, but for example, in Enterprise Manager,
if someone asks me "What permissions on the database does Joe Bloggs in
Accounts have?" I just look up Joe Blogs login, right-click and choose Manag
e
Permissions. I check the box for only showing permissions explicitly defined
and there it is.
I can't DO that in Management studio.
I had a quick look through the functions in master, but the permissions ones
just seem to be concerned with the *current* user. I can see the value of
these... do the test, and if the can, then do the action.
But for a harrased admin being asked the above question... what can be done?
I don't mind cobbling up soem T-SQL to return the perms if required, but it
must be able to be run for any login, not jsut the current one.
BAzz
"Uri Dimant" wrote:
> Hi
> IF PERMISSIONS()&2=2
> CREATE TABLE test_table (col1 INT)
> ELSE
> PRINT 'ERROR: The current user cannot create a table.'
> --
> This example determines whether the current user can
> grant the INSERT permission on the authors table to another user.
> IF PERMISSIONS(OBJECT_ID('authors'))&0x80000=0x80000
> PRINT 'INSERT on authors is grantable.'
> ELSE
> PRINT 'You may not GRANT INSERT permissions on authors.'
> --http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsq
lref/ts_pa-pz_6f78.asp>
> How can I retrieve a list of objects and permissions for a specified role
?
> ----
--
> In SQL Server 2005, you can use the Has_Perms_By_Name() function
> (http://msdn2.microsoft.com/en-us/library/ms189802.aspx).
>
> This is an example of usage:
> SELECT o.SchemaAndName,
> has_perms_by_name(o.SchemaAndName, 'OBJECT', 'EXECUTE')
> FROM (SELECT name, SCHEMA_NAME(schema_id) AS [schema],
> SCHEMA_NAME(schema_id)+'.'+name AS SchemaAndName
> FROM sys.objects
> WHERE type = 'P') AS o
>
>
>
>
> "BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
> news:D130E054-26BD-4AB2-85BE-F4153BB7E7DD@.microsoft.com...
>
>|||BAzz,
Assuming that you are a system administrator for the SQL Server, you can
execute in the context of the login that you are checking. Here is a
sample:
EXECUTE AS login='MYDOMAIN\MyLogin'
SELECT name, is_member(name) FROM sys.database_principals
WHERE is_member (name) = 1
SELECT name, (permissions(object_id)) FROM sys.objects
WHERE permissions(object_id) > 0
REVERT
FWIW, RLF
"BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
news:A8D05A43-38F5-4461-8334-06B8D4FBDC99@.microsoft.com...[vbcol=seagreen]
> Ok, thats all very well for coders, but for example, in Enterprise
> Manager,
> if someone asks me "What permissions on the database does Joe Bloggs in
> Accounts have?" I just look up Joe Blogs login, right-click and choose
> Manage
> Permissions. I check the box for only showing permissions explicitly
> defined
> and there it is.
> I can't DO that in Management studio.
> I had a quick look through the functions in master, but the permissions
> ones
> just seem to be concerned with the *current* user. I can see the value of
> these... do the test, and if the can, then do the action.
> But for a harrased admin being asked the above question... what can be
> done?
> I don't mind cobbling up soem T-SQL to return the perms if required, but
> it
> must be able to be run for any login, not jsut the current one.
> BAzz
>
> "Uri Dimant" wrote:
>|||Thats a great help, thanks. the Execute as... will do the trick in a
parameterised stored proc that I can have return a formatted list of perms..
Makes me wonder, though, why the functionality was removed from the 2005
Management studio.
"Russell Fields" wrote:
> BAzz,
> Assuming that you are a system administrator for the SQL Server, you can
> execute in the context of the login that you are checking. Here is a
> sample:
> EXECUTE AS login='MYDOMAIN\MyLogin'
> SELECT name, is_member(name) FROM sys.database_principals
> WHERE is_member (name) = 1
> SELECT name, (permissions(object_id)) FROM sys.objects
> WHERE permissions(object_id) > 0
> REVERT
> FWIW, RLF
>
> "BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
> news:A8D05A43-38F5-4461-8334-06B8D4FBDC99@.microsoft.com...
>
>|||FWIW, I wonder, too. The current Studio behavior is not helpful to me
either.
RLF
"BAzz" <Barry.Freeman@.nospam.co.uk> wrote in message
news:0FF6C000-6010-4119-B1DB-E84047507080@.microsoft.com...[vbcol=seagreen]
> Thats a great help, thanks. the Execute as... will do the trick in a
> parameterised stored proc that I can have return a formatted list of
> perms..
> Makes me wonder, though, why the functionality was removed from the 2005
> Management studio.
>
> "Russell Fields" wrote:
>
Determining the number of Active users logged into a SQL Server Database
How does one Determine the number of Active users logged into a SQL Server Database?
I want to use the info to control concurrent licensing for my Application
This query will give you a count grouped by DB, you can also use sp_who or sp_who2
select db_name(dbid),count(*) from master..sysprocesses
where spid > 49 --everyting below 50 is SQL Server itself
group by db_name(dbid)
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||Thanks, I will. I believe this is exactly what I am looking for. Is it safe to assume that the data is available in "real time"? Also if a user logged in to the DB drops his connection by doing something stupid like powering off his workstation without closing the app first, will the count be reduced, the next time it is run?|||Yes the data is real time, the server connection will disapear once the connection times out or the connection has been removed from the connection pool.
Subscribe to:
Posts (Atom)