extended-properties

Recommend a tool to manage Extended Properties in SQL server 2005

Server Management Studio tends to be a bit un-intuitive when it comes to managing Extended Properties, so can anyone recommend a decent tool that improves the situation. One thing I would like to do is to have templates that I can apply objects, thus standardising the nomenclature and content of the properties applied to objects. Many ...

How to get rid of extended table properties in SQL Server 2000?

I'm re-casting a question I asked earlier now that I have an idea of the cause of the problem I'm seeing. What I have: Tables in a DB on SQL Server 2000. I view/edit the tables with Access 2007, with SQL Server Management Studio 2005, and occasionally with SQL 2000 Enterprise Manager. What I did: I tried to copy the DB from SQL Serv...

Extract SQL Column Extended Properties From LINQ in C#

Hi, i have an SQL table with extended properties on each column. Is there a way to access these from LINQ in c# using Linq2SQL? ...

SQL Server Extended Property MS_SubdatasheetName

Our application uses a SQL Server back-end with many stored procedures. Recently, while trying to fix an unrelated problem, we scripted a stored procedure to an ALTER statement to a SQL window to try something. Renaming our proc for testing purposes, we ran the script, and got this perplexing error: Msg 15233, Level 16, State 1, Proce...

Google Data API: what is the limit of Extended Properties?

Is there any limit on number of properties and value length in Extended Properties of Google Data API (in particular Calendar API)? ...

querying extended File Properties using WMI

Is there a WMI namespace and a class that can be used to obtain the extended properties of a file, such as Owner, Author, Title, Subject, Category, Comments? please suggest. ...

Can you explain the use of sys.sp_addextendedproperty in the following code?

What's going on in the following code after the View is created? Can you give me any thoughts or path to follow? This code is taken from here. /****** Object: View [dbo].[vProductImages] Script Date: 04/28/2008 16:59:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[vProductImages] AS SELECT dbo....