Tech Tutorials Database
GeekArticles Database SQL Server
 

Tip: Using sp_addextendedproperty in order to add a property that's longer than 255 characters.

 
Author: novicksoftware.com
Category: SQL Server
Comments (0)

SQL Query Analyzer's UI limits extended properties to 255 characters. This tip shows how to add bigger extended properties and the UDF required to get them back from SQL Server's sysproperties table.

Read More...




Sponsored Links




Read Next: Trace Messages Part II: Writing to the Trace



 

 

Comments



Post Your Comment:

Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe