Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aviad.co1
Starting Member
4 Posts |
 Posted - 2010-06-07 : 13:51:01
|
| yes, thank's.I create this stored procedure below, but I get this error when I try to update the properties :property cant be add. property 'Domain' already exists for 'object specified'.the code :CREATE PROCEDURE tiy1909 @domain nvarchar(100),@db_name nvarchar(100)ASdeclare @str nvarchar(100)if 'Domain' in (select name from sys.extended_properties)BEGINset @str = 'USE '+@db_name+'; EXEC sp_updateedextendedproperty @name=''Domain'',@value='''+@domain+''';'EXEC sp_executesql @strEND ELSE BEGIN set @str = 'USE '+@db_name+'; EXEC sp_addextendedproperty @name=''Domain'',@value='''+@domain+''';'EXEC sp_executesql @strEND mybe someone can help me, thanks |
|
|
aviad.co1
Starting Member
4 Posts |
Posted - 2010-06-07 : 14:53:54
|
| I fix it but I still have a error - property cant be updated or deleted.property 'Domain' does not exist for 'object specified'.this the new code :CREATE PROCEDURE yyeess51 @domain nvarchar(100),@db_name nvarchar(100) AS declare @str nvarchar(100) declare @str1 nvarchar(100) set @str = 'USE '+@db_name+';' EXEC sp_executesql @str if 'Domain' in (select name from sys.extended_properties) set @str1 = 'USE '+@db_name+';EXEC sp_updateextendedproperty @name=''Domain'',@value='''+@domain+''';' else set @str1 = 'USE '+@db_name+';EXEC sp_addextendedproperty @name=''Domain'',@value='''+@domain+''';' EXEC sp_executesql @str1thank's, you help me a lot. |
 |
|
|
|
|
|
stored procedure