I have used many different queries of DMV/DMF over the past years to get various information for SQL Server OS. So I am going to
Install SQL Server 2008
Microsoft has made the SQL Server 2008 install more function rich then the previous version. They have included functionality into this install which make it
Mirroring FAQ
I plan to update this as I run across questions; I really like mirroring. Comparing to Clustering it is cheaper to setup also. I like
Mirroring Scripts
When I setup mirroring between servers on SQL Server 2005 I use following scripts: SQL2K5MirroringScript-MirrorServer.sql SQL2K5MirroringScript-PrincipleServer.sql SQL2K5MirroringScript-WitnessServer.sql These scripts rely are designed and rely on
Can’t Modify/Delete Maintenance Plans in SQL 2005 after Rename
Credit: Tracy (SQL Server Central, Link) After renaming SQL Server 2005 server the maintenance plans couldn’t be deleted. When trying to delete or modify a
OSQL and Code Page Settings
Credit: Carl B. (SQL Server Central, Link) In SQL Server 2000, when using OSQL it is difficult to work with import files that are in