Latest SQL Server General DBA FAQ's

Site sponsored by:

Try Idera’s new SQL admin toolset

Home

Articles

Forums

Tips

FAQ's

Blogs

Software

Books

About Us

RSS Feeds

FAQ Topics

All FAQ's

General DBA

General Developer

DBA Performance Tuning

Developer Performance Tuning

Clustering

Error Messages

SQL Server 2008 - Worth the Wait

SQL Server’s first significant upgrade in three years features a number of envelope-pushing enhancements and improvements. Which will have the greatest impact on SQL administration and development? More...

Latest Articles

Slowly Changing Dimensions in SQL Server 2005

Audit Data Modifications

SQL Server 2008’s Management Data Warehouse

Same Report but Different Methods in SQL Server Reporting Services ...

	Database Mirror Certificate Expired
	How to replicate more than 256 articles in Merge Replication?
	SQL Server 2005 - clients using native client, should clients be upgrade as well
	How to Configure Multiple SQL Server Reporting Service Instances on the Same Computer
	Error When Configuring SSRS Database
	How to Access a Map Drive from SSIS ?
	How can I force SQL Server 2005 logins to change their passwords periodically?
	What permission does the user need to run PROFILER in SQL Server 2005?
	How can I drop all the instances attached to one Database?
	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?
	IN SQL Server 2005, how do I backup the sys.asymmetric_keys and sys.symmetric_keys tables?
	How to resolve SQL Server Management Studio error: 'Could not load file or assembly 'SqlManagerUI ...'?
	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?
	Is it possible to set the database name in advance when deploying client database with an installer option?
	How do I get the taskpad view in SQL Server Management Studio as it was in SQL Server 2000 version?
	DTS package error "Cannot find specified package in the storage location specified".
	Unable to install Service Pack 1 for SQL Server 2005 version.
	How to get resource usage of an executing query in SQL Server without using SYSMON/PERFMON utility?
	Can you provide the scripts that you use to transfer (copy) logins from a primary server to a secondary server?
	How do you get rid of users that are already in the database on the backup server when a restore starts?
	Should we automatically reboot our SQL Servers on a weekly basis?
	Why do I get an unordered resultset, although my table has a clustered index?
	Can I downgrade my SQL Server databases to an earlier version?