This post contains 10 Must Read articles that were published in the year 2009 on SQLServerCurry and contains SQL Server Administration scripts to perform some common administration tasks on your SQL Server database
Generic SQL Server Stored Procedure to display Table Names of any Database passed to it
Set a database to read only mode using SQL Server 2005/2008
Delete BackUp and Restore History for databases in SQL Server 2005/2008
How to do a Full and Differential Database Backup in SQL Server
SQL Server 2005 and 2008 Diagnostics Queries and Configuration Checklist
Find Out Tables in a Database Having Identity Columns
Enable and Disable All the Triggers in a SQL Server Database
Recompiling Stored Procedures in SQL Server – All, Few or One at a time
How to Create a SQL Server Agent Proxy Account
Programmatically Change the default path for SQL Server Database creation
To read some more articles on SQL Server Administration, check here
No comments:
Post a Comment