User account management
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

Linked SQLServer
Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.

Answer Question   |  April 27, 2009  10:49 AM
Linked SQL Servers, SQL Server 2005, SQL Server database, SQL Server Linked Server

SQL Server Linked Server Security Context
Hey everyone, I’m working on some scripts that will run on a monitoring server and connect to several data servers to return information such as job status, etc. We also use linked servers for replication, etc. We use mixed authentication, however, I would like to change our linked servers to use the current security context [...]

Answer Question   |  March 28, 2009  1:56 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server Linked Server, SQL Server security