General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Setting Extended Properties in SQL Server
Environment versions
Network:
Windows 2008 Server
Can anyone spot any problems with the following command which I use to add meta data to a SQL Server table?
cdescription = [']+ALLTRIM(adstruct.definition)+[']
colname = [']+ALLTRIM(adstruct.field_name)+[']
lnRet = SQLEXEC(handle28,[execute sp_addExtendedProperty 'Description',];
+cdescription+[,'schema','dbo', 'table', 'recentclaimdet', 'column', ]+colname)
I had it working but now I must have introduced a bug that I can't see. Always returns minus 1.
Handle is a valid handle.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only