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
Sub-Folder Grouping for Folders
When managing large SQL Server instances; the number of databases on a server sometimes start creating a headache to manage. If we can group the
Top Tips for Effective Database Maintenance
Tip Tips for Effective Database Maintenance
Inserting into Linked Servers
Recently I was trying to help someone on Microsoft Newsgroups with issue with Linked Server. When inserting into Linked Server directly via the SQL Statement
SQL Canada (SQLCAN) 