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
Schema Binding: Views
Schema Binding is there to stop the accidentally removal of required columns from a table. If SCHEMABINDING is in the create statement of an object