how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .
Answer Question | June 25, 2010 11:55 AM
SQL Server, SQL Server 2008, SQL Server User Accounts
We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. – aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.” When we login from the user computer with the same name [...]
Answer Question | April 9, 2010 3:38 PM
SQL Server 2000, SQL Server database, SQL Server User Accounts
Hi, I’m using sql server 2005 and in my application i have 2 DB say A and B , and 2 servers SR1,SR2 and DB A,B and present on both (SR1,SR2).now i want to give access to users entering my DB not to view any of the entries made in the DB, not even the [...]
Answer Question | January 7, 2010 6:29 AM
SQL Server 2005, SQL Server permissions, SQL Server User Accounts, Windows Vista
Plz forward me the solution of the above query. Thanks & Regards, Gangadharan M
Answer Question | November 12, 2009 4:54 AM
SQL Server authentication, SQL Server User Accounts
Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.
Answer Question | June 25, 2009 4:26 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration, SQL Server permissions, SQL Server User Accounts, SQL Server user permissions, Upgrade from SQL Server 2000 to SQL Server 2005
I have taken over the management of around 50 sql servers with responsibility for the creation and deletion of user accounts on each server. To assist with the maintenance of user accounts how would i create a central respository of all users names by server that i could query. Could i use linked servers?
Answer Question | April 27, 2009 12:51 PM
SQL Server Linked Server, SQL Server Management, SQL Server User Accounts