Category: General DBA
In SQL Server 2005 how to determine the role memberships and the permissions associated with login yy?
Using SQL Server 2005 how to find a user or login that has the db_owner role in any database?
How to resolve SQL Server Management Studio error: 'Could not load file or assembly 'SqlManagerUI …'?
IN SQL Server 2005, how do I backup the sys.asymmetric_keys and sys.symmetric_keys tables?
For optimum security, is it recommended to use a single domain account the SQL Server instances in a network?
What is the best way to test the upgrade process from SQL Server 7.0 or 2000 to SQL Server 2005, before I perform the actual upgrade?
In SQL Server 2005, when I'm trying to open the Database Maintenance Wizard, I get an error message telling me that "Agent XPs" are not running. How can I resolve this problem, and what are "Agent XPs?"
What is the purpose of the Surface Area Configuration Tool in SQL Server 2005?
How can I enable xp-cmdshell on a SQL Server 2005 instance?