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

Categories

Editors Picks

Download CX-310-015 Free Exam Simulator

Download CX-310-014 Free Exam Simulator

Download SCEA Free Exam Simulator : 310-051

VB NET 2005 Training The NET Framework Architecture Part 1

Oracle Applications 11i Technical Training

MSAS Step by Step Tutorials

Oracle 9i Step by Step Tutorials

ASP.NET with C# Training

Live DataStage Interview Questions

SCJP for Java 2 Platform 1.4 CX-310-035 Free Exam Simulator

IT Interview Questions

IT Experts Online Journal

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

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

Hits: 2485

Description: 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.

Visit Tip: Using sp_addextendedproperty in order to add a property that's longer than 255 characters. `s Website
Write a Review!	Report This Link

Related Links in this Section

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)

SQL Server 2005 Webcasts

Reading a Trace File using C# in SQL Server 2005

PASS 2004 Presentation: Profiler and Trace in SQL Server 2005

Automatically Process SQL Server Trace Files

Microsoft SQL Server Health and History Tool

The Daily Database Build

Trace Messages Part IV: Getting the Trace Results

Trace Messages Part III: Session End an Metrics

Trace Messages Part II: Writing to the Trace

Trace Messages Part I: Managing Application Sessions

Create a User Defined Aggregate with SQL Server 2005

Finding the SQL Server Agent ErrorLog

Searching the SQL Server ErrorLog with a Stored Procedure

Query Analyzer Templates for UDFs

Book Review: A First Look at SQL Server 2005 for Developers

Distributing the Smart Client Application

Programmer's Shop Open at CafePress

MSAS Step by Step Tutorials

Understanding SQL Server Licensing

Explore SQL Server 2000 DTS Packages Using .NET and the DTS Class Library

A Comparison of SQL Server 7.0 with SQL Server 2000

Microsoft SQL Server: SQL Server 10-Year Anniversary

Data Cleansing Applications with SQL Server Integration Services

SQL Server for Developers: Detecting and Resolving Stalled and Stuck I/O Issues in SQL Server 2000 SP4

Hackers Beware: Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005

Building SQL Server Integration Services Packages

Usage Scenarios for SQL Server 2005 Native Web Services

SQL Server Professional: SQL Essentials: SQLCMD in SQL Server 2005 Beta 2

Processing XML Showplans Using SQL CLR in SQL Server 2005

Data Points: Data Access Strategies Using ADO.NET and SQL

Step by Step Oracle PL-SQL Tutorial

Resource Specification
Date Added:	03/08/2005
Last Updated:	03/08/2005

Average Visitor Rating: Not Yet Rated

Visitor Voting

Average Member Rating: Not yet reviewed by any member...
You can be the first one to write a review for Tip: Using sp_addextendedproperty in order to add a property that's longer than 255 characters.!