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
Activity Monitor in SQL 2008 …
It disappeared … So it seems; it no longer shows up under Management -> Activity Monitor. Even on-line books state it is there. I still
INSERTED and DELETED Logical Tables
The INSERTED and DELETED logical tables that exist in SQL Server and allow for handling the data when information is inserted, updated and deleted in
"No description found" Error when modifying Maintenance Plans
When you are trying to modify a maintenance plan; sometimes you might get “No Description Found” error and you cannot do any work in SSIS
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
SQL Canada (SQLCAN) 