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
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
"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 Files Being Perceived as Text Files
When trying to open SQL File on the web through Internet Explore (IE) sometimes it will show the file right in IE because it thinks
Error 14274: Cannot add, update, or delete a job (or its steps or schedule) that originated from an MSX server.
You can get this error when trying to modify the properties of a Job after the SQL Server has been renamed or cloned into another
SQL Canada (SQLCAN) 