Questions tagged [extended-properties]

101 questions
0
votes
1 answer

Get metadata from extended properties (SQL Server)

I am building a data dictionary and trying to get some info from the extended properties. I have a script to add extended properties (working as expected). EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This column stores the…
0
votes
1 answer

Is it possible to query a null extended property in SQL Server?

I am trying to come up with a way to query a result set that returns the schema/table/column for any column that doesn't have an extended property associated with it so my team can understand where to add documentation. That being said...is it…
Trace R.
  • 307
  • 3
  • 13
0
votes
2 answers

SMO doesn't retrieve extended properties for index

I'm trying to use SQL Server Management Objects (SMO) to retrieve an extended property on an index, but the retrieved SMO object has an empty ExtentedProperties collection. (The index is on a table.) The extended property is there, I checked in…
user812775
  • 153
  • 1
  • 9
0
votes
0 answers

Unable to locate specific message by SingleValueExtendedProperty

I have an app that tries to send an email message using the Microsoft Graph, and then retrieve that same message for importing some information into our database. After researching this, the suggested trick is to attach unique piece of information…
0
votes
0 answers

Excel VB - Shell object and Items extended properties

First of all i'm not a VB geek, but I've found my way through googling around and I just can't figure out this one... Put simply, I made a macro that allows me to select pdfs, zip them, and build a list of those zipped files on another sheet, then…
aardvark
  • 9
  • 3
0
votes
1 answer

How to get EndRecurrenceDate using microsoft graph api

I am trying to get EndRecurrenceDate using ms graph api by referring this documents .link 1 none of followings didn't work for me . what could be the reasons…
0
votes
1 answer

Update an ExtendedProperties or Approval Comments of Sharepoint task item

I am trying to update a SharePoint task programmatically using CSOM. I am able to approve a task successfully but not sure how to update the comments. The comments could be retrieved using ExtendedProperties as HashTable but I am unable to set the…
Ishan
  • 4,008
  • 32
  • 90
  • 153
0
votes
4 answers

How do I map the id in sys.extended_properties to an object name

When we codegen our CRUD stored procs, we add an extended property that indicates the table they are based on. I want to be able to interrogate sys.extended_properties to get a list of procs that depend on a given table, but extended_properties…
Rikalous
  • 4,514
  • 1
  • 40
  • 52
0
votes
0 answers

Combining Two extended properties with one Left Join

I'd like to have two columns show up that represent my extended properties. I was able to have one extended property showing column_description, but would like to include both extended properties with on left join. I tried to make a case statement,…
Dave
  • 31
  • 2
0
votes
0 answers

How to call a method from extended class with class name in PHP

Let's say I have 3 classes and methods in it; file1.php class A { public function insert() { /* some code to do something with DB */ } } file2.php require file1.php class B extends A { public function sample() { /* doing…
Athul AK
  • 358
  • 4
  • 15
0
votes
1 answer

Extended property not adhering to EmailMessage

I am running code that looks to add an extended property along with a value. Seems to run fine. When I iterate over the MailItems, I do not see any evidence of the extended property. Code to extend: EmailMessage email2 = EmailMessage.Bind(service,…
0
votes
1 answer

Why can't I use an inline expression in sp_addextendedproperty but I can use a variable?

When I run this T-SQL on a SQL Server 2016 database with compatibility level 130 I get an error: DECLARE @myVariable int = 4; EXEC sys.sp_addextendedproperty @name = N'MyExtendedProperty', @value = FORMAT( @myVariable, 'd', 'en-US' ), …
Dai
  • 141,631
  • 28
  • 261
  • 374
0
votes
1 answer

Woes with copy operation and extended properties in EWS

I am tasked with bidirectioanlly synching contact folders in two mailboxes with a service. Please bear with me, as this is the first time I'm using EWS in C#. In order to uniquely identify items and track changes for synching, I am utilizing…
namezero
  • 2,203
  • 3
  • 24
  • 37
0
votes
1 answer

Creating Multiple Extended Controls

I have created an Extended TextBox that Inherits a standard WPF TextBox, what I am now trying to do is create other extended control types like a TextBlock, ListBox, ComboBox etc. All controls will have the same DependencyProperties as shown below…
0
votes
1 answer

Can I set extended properties to a meeting that i'm gonna create using Send button?

Can I set extended properties to a meeting that i'm gonna create using Send button from meeting window? Are there any alternatives for setting extended properties to o meeting besides creating the meeting using OfficeJs EWS request CreateItem?