Stack Overflow
Stack Overflow

Questions tagged [extended-properties]

101 questions
2
votes
2 answers

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,…
Martin
  • 39,569
  • 20
  • 99
  • 130
2
votes
3 answers

Extract SQL Column Extended Properties From LINQ in C#

i have an SQL table with extended properties on each column. Is there a way to access these from LINQ in c# using Linq2SQL?
Grant
  • 11,138
  • 32
  • 94
  • 140
2
votes
0 answers

Get Extended Property in edmx modeling Db

I have a database modelling by Entity Framework. I need to read the extended properties of each table through the object context associated to my Db. How can i do? Thank's in advance
Valentina Tavanti
  • 21
  • 1
2
votes
1 answer

Store metadata outside of file: Any standard approach on modern Windows?

My C# app syncs files from a remote document management system to a filesystem. The document management system has metadata (date of last audit, secrecy, author...) which is associated with each file but not stored WITHIN each file. The files can be…
Nicolas Raoul
  • 58,567
  • 58
  • 222
  • 373
2
votes
2 answers

Filter extended properties by contact id

With this code I get the extended properties for contacts with a specific display name: foreach(Contact c in contacts) { // some code... view.PropertySet = new PropertySet(BasePropertySet.IdOnly, properties); filter = new…
Thiago
  • 1,103
  • 1
  • 16
  • 25
2
votes
1 answer

EWS - How to know contact fields extended property id?

I have to add values to some outlook contact fields using EWS. I've managed to do that with the 'User Field 1' using this article . The problem is that i need to insert values in other fields (for instance 'Account' in 'Miscellaneous Fields') and I…
Thiago
  • 1,103
  • 1
  • 16
  • 25
1
vote
1 answer

Is it possible to get a list of tables which don't have a specific extended property?

First things first: I am using Microsoft SQL Server Management Studio (if you need more information, just tell me). Here is my problem: I have a really high number of tables and I am trying to bring some structure to it. My team decided to 'just'…
Chris
  • 13
  • 2
1
vote
1 answer

Having problems getting SingleValueExtendedProperties into a Graph Event, it always comes up null when I look at it in debug

I run the following code to create an Event on my Outlook calendar, which it does except that the SingleValueExtendedProperties is null. I stepped thru the code and saw that @event contains both properties as I had added but after I step thru…
L. Joseph Poyner
  • 11
  • 2
1
vote
1 answer

Querying system tables EXTENDED_PROPERTIES much slower on SQL Server 2016 than SQL Server 2008

We have an application that uses the extended properties to hold columns meta data. The columns have extended properties to hold the field description, option values, position on screen etc. There is a view that queries these extended properties,…
BdR
  • 2,770
  • 2
  • 17
  • 36
1
vote
1 answer

Edit SQL Extended Properties in SharePoint 2010

How can I edit extended properties of a table in SharePoint 2010? So far, I'm thinking there's nothing 'out-the-box' that does this. So, I'm assuming this means that I will have to make a custom web-part that extracts the extended properties of a…
pfaruiz
  • 21
  • 1
  • 5
1
vote
2 answers

DataColumn.ExtendedProperties Data to GridView

What is the best way for me to access extended properties of a DataColumn on rowDataBound and apply a certain class and tool-tip if the error key exists? protected void gridView_rowDataBound(object sender, GridViewRowEventArgs e) { switch…
kzh
  • 19,810
  • 13
  • 73
  • 97
1
vote
2 answers

Read ExtendedProperties from Outlook Add-In

I am currently setting custom ExtendedProperties on a CalendarFolder using EWS Managed API (C#): myCalendar.SetExtendedProperty(customExtendedProperty, true); I can also use the Managed API to load those settings when I bind the CalendarFolder: var…
Andy T
  • 10,223
  • 5
  • 53
  • 95
1
vote
2 answers

Android Calendar Provider: Only initially created extended property syncs across devices, all further updates do not sync

When I create a Google Calendar event and attach extended property to it, all is working as expected - both event and its extended property get synced so they can be accessed from different devices. Here is the code: // create event with extended…
Zmiter
  • 298
  • 4
  • 15
1
vote
1 answer

How to add extended properties in PostgreSQL

Is it possible to add a kind of Extended Properties in tables and/or columns in PostgreSQL as we can do in SQL Server? I've been looking for this in Google, but I can't find anything about it. I want to describe columns (data dictionary) and add…
Maximus Decimus
  • 4,901
  • 22
  • 67
  • 95
1
vote
1 answer

Use extended properties for documentation purpose?

I am intending to use extended properties for documentation. So, to save descriptions and comments to tables, views, etc. Like this: EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'custom description text', …
SQL Police
  • 4,127
  • 1
  • 25
  • 54
1 2
3
4 5 6 7