Questions tagged [extended-properties]
101 questions
0
votes
1 answer
T-SQL script for extended properties
Database DatabaseDesc TableDesc ColumnDesc StoredProcedureDesc ParameterDesc FunctionDesc
'DB Name' 100% 90% 80% 75% 76% 40%
If extended property for database description exists column…
0
votes
1 answer
How to access parent's class property if the current class has been instantiated in the parent
I'm experimenting with MVC trying to make a simple framework. This is an example of what I'm doing:
enzo
- 624
- 6
- 12
0
votes
1 answer
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…
Paul Williams
- 16,585
- 5
- 47
- 82
0
votes
2 answers
Avoid populating Extended Properties in WCF data contracts
How could I avoid populating the ExtendedProperties collection in my data contract?
My WCF service is building the data contract from a XML and populating the ExtendedProperties with the properties that are not in the contract. Then they are…
user2214951
- 31
- 4
0
votes
0 answers
Adding extended properties to all stored procs
We're trying to add versioning to a ms sql database. Since the database has now been deployed to over 400 branches and with the clients insistence in staggered rollouts it has become very difficult to manage which branches have which db fixes.
I've…
Tal Even-Tov
- 153
- 2
- 11
0
votes
1 answer
Extended properties in Enterprise Library Logging Block
I'm using Enterprise Library 5 Logging block for logging in my windows application, also i defined some extended properties for my log entry, when i define a Database trace listener, and use it to log my message, where are saved my extended…
Masoud
- 8,020
- 12
- 62
- 123
0
votes
2 answers
Extended properties for access table
I can set extended properties for SQL server tables. Can i set extended properties for access database table? If possible then how i can set extended properties?
wincoding
- 65
- 1
- 10
0
votes
2 answers
Exchange Web Services - How to retrieve a Contact using the Account extended property
I am using C# and the Exchange Web Services API and have been unable to find a way to retrieve a contact using the extended property named Account. We have used this field to hold an integer number that is meaningful to an in-house developed…
Bill Mitchell
- 161
- 1
- 4
0
votes
1 answer
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…
John
- 15,990
- 10
- 70
- 110
0
votes
1 answer
How to save a binary file in extended property?
I use this code to save a string in my extended property,
EXEC sp_addextendedproperty @name = N'SampleProperty1', @value = N'SampleValue1'
My question is, can I use that code when saving a binary file like an image?
illumi
- 458
- 1
- 14
- 32
-2
votes
1 answer
Is there an easy and convenient way to use SQL Server extended properties for automatic documentation?
To use extended properties for documentation is a striking thought, or to have a easy way to tag your tables, but to set a snippet of documentation you have to execute something like:
EXECUTE sp_addextendedproperty
@name = N'MS_Description',
…
cjonas
- 71
- 1
- 4