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
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
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
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
SQL Canada (SQLCAN) 