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

Author: novicksoftware.com | Published: 10th Aug 2005 | Visited: 591 times | Add Comment
Filed in: SQL Server

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 Article

Sponsored Links

• Business object property validation How to set and validate properties in a single line of ...

• Introductions are in order Hello all. My name is Griffin Caprio and I'm a new blogger here on xml.com. Apologizes are in order to Kurt, my fearless editor, since this is my first post and I actually came into the O'Reilly fold back i ...

• Property Generator Tool An Approach to minimize issues when using properties in ASP. ...

• SOA Governance Brings Order to Services Chaos Your most valuable SOA assets are worthless if you and your team can't find, use, and manage them. Find out how IBM Rational Asset Manager and IBM WebSphere Service Registry and Repository's governance solution can help you maximize your SOA investment to meet your business ne ...

• After installing RAD2007 (trial), BDS2006 no longer starts QC#: 54163 Version: 11.1 Status: Closed defect, no action required Resolution: Behavior is as designed Description: The so-called "non breaking" release breaks a BDS2006 installation. An attempt to start the Win32 personality of BDS 2006 will result ...

• Leaveraging GenericType Converter for Hybrid Property Databinding Leaveraging GenericType Converter for Hybrid Property Databin ...

• WPF Business Application Series Part 2 of n - Form Notification Control That Binds To IDataErrorInfo... WPF VB.NET Business Application Form Notification control that binds to business entity objects that implement the IDataErrorInfo interface. The article also covers entity validation with the WPF 3.5 IDataErrorInfo interf ...

• Generic Multi-Field/Property Sorting for Lists of Business Objects This article presents a simple and flexible way to sort strongly-typed lists of business objects using multiple properties or fie ...

• Code Completion appends read specifier to write only property QC#: 11994 Version: 9.0 Status: Open defect, requires resolution Resolution: Bug is a duplicate (must note dup bug #) Description: In a class definition, pressing Shift+Ctrl+C will automatically convert property SomeData: string write FSomeData; to ...

• WPF and Property Dependencies Part I An introductory look at WPF data binding and property dependenc ...

Next: Trace Messages Part III: Session End an Metrics