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
Category: SQL 2005
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
Default Schema in SQL 2005/SQL 2008
When you create a new AD group login in SQL Server and then create the Database user based of that login it is not possible
Default Backup Path in SQL 2005
If you have changed your backup path from default location (i.e. the location SQL was set to backup when it was installed) to a different
Missing Options in Script Generation in SSMS
I was generating scripts in the Management Studio for all objects. Everything looked great; I created my new database with same structure. Before I let
Database Mirroring: Fully Quanlified Domain Name (FQDN) Error
If you are trying to setup Database Mirroring, it prefers to see a FQDN for the servers when entering partner information. If you don’t you’ll
SQL Canada (SQLCAN) 