MS SQL Server - Admin notes

Defaults

When you create a table, you will notice that columns have two parameters - Default Value and Default Object.

• Use Default Value if you wish to specify a particular value for the default. Note that you should enclose any string values in single-quotes.
• Use Default Object if you have already created a Default (using the Create Default command) and wish to link this column to that Default.

Triggers and Procedures

If you select the Encrypted option, the trigger / procedure text will not be visible in the system tables. Consequently the trigger or procedure cannot be viewed or amended.

Renaming Objects

If you rename a view, trigger, procedure or function, you will have a mismatch between the object name and the name referred to in the Create text held in the database. This can result in the wrong name being used when the object is being amended, or when the DDL is generated.