- Code: Select all
PRINT N'Dropping extended properties'
EXEC sp_dropextendedproperty N'MS_Description', NULL, NULL, NULL, NULL, NULL, NULL
I thought that was odd, but ignored it.
Then I use Packager to build an exe based on the script. But when I run the exe to upgrade my database, I get this error:
Property cannot be updated or deleted. Property 'MS_Description' does not exist for 'object specified.
I can just remove that line of code from the script and it will work, but I wanted to see if this is a bug or if I'm doing something wrong. BTW, I do not want to "ignore extended properties" because I want the script to account for those changes - if there are any.