Script to simplify maintenance of sysproperties

This procedure will maintain the sysproperties table by wrapping system procedures:                • sp_addextendedproperty                • sp_dropextendedproperty                • sp_updateextendedproperty            The parameters are:                • @object    --    primary name of the object being to be maintained.                • @column    --    column or parameter […]

2007-07-04

418 reads

Script to simplify maintenance of sysproperties

This procedure will maintain the sysproperties table by wrapping system procedures:                • sp_addextendedproperty                • sp_dropextendedproperty                • sp_updateextendedproperty            The parameters are:                • @object    --    primary name of the object being to be maintained.                • @column    --    column or parameter […]

2007-07-04

74 reads

Blogs

Adding a Check Constraint to a Table–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Azure SQL Database Elasticity – Presentation Notes

By

This blog covers the content and points to the code used to create the...

How To: Create Schema Only Database Copies

By

Have you ever been asked to make a schema only copy of a database?...

Read the latest Blogs

Forums

query

By sankaripr

Hi i have 3 table that need to find out which id missing two...

Joining 2 select results into a single row

By mtz676

select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as...

deleted duplicate post

By mtz676

deleted duplicate post

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers