GeekArticles
Database
SQL Server
Database
SQL ServerTip: Using sp_addextendedproperty in order to add a property that's longer than 255 characters.
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.
Sponsored Links
Read Next: Trace Messages Part II: Writing to the Trace
Related Topics
Subscribe via RSS
SQL Server
- Naming Database Objects: Part II
- Trace Messages Part V: Trace Cleanup
- Naming Database Objects: Part I
- Multiple-Child Aggregation
- Creating SQL Tables for an Integrating Application Using Dexterity
- SQL Server 2005 Beta 2 Transact-SQL Enhancements
- .NET Rocks! - Brian Larson on SQL Server Reporting Services
- Computing the Trimmed Mean in SQL
- SQL Server 2000 Gains on Oracle
- Separator First Formatting (SFF)
