PowerDeisnger16下导出到sqlserver2005以上出现sysproperties错误的解决办法

概述---------------------------------TableComment------------------------------ [if exists (select 1              from  sys.extended_properties            where  major_id = object_id('[%QUALIFIER%]%TABLE% ---------------------------------tableComment------------------------------
[if exists (select 1 
            from  sys.extended_propertIEs
           where  major_ID = object_ID('[%QUAliFIER%]%table%') 
            and   minor_ID = 0) 
begin 
   [%OWNER%?[.O:[execute ][exec ]]sp_dropextendedproperty [%r%?[N]]'MS_Description', 
   [%r%?[N]]'user',[%r%?[N]]%.q:OWNER%,[%r%?[N]]'table',[%r%?[N]]%.q:table% 
:declare @CurrentUser sysname 
select @CurrentUser = user_name() 
[.O:[execute ][exec ]]sp_dropextendedproperty [%r%?[N]]'MS_Description',[%r%?[N]]@CurrentUser,[%r%?[N]]%.q:table% 
] 
end 




][%OWNER%?[.O:[execute ][exec ]]sp_addextendedproperty [%r%?[N]]'MS_Description', 
   [%r%?[N]]%.q:COMMENT%,[%r%?[N]]%.q:table% 
:select @CurrentUser = user_name() 
[.O:[execute ][exec ]]sp_addextendedproperty [%r%?[N]]'MS_Description',[%r%?[N]]%.q:table% 
] 
---------------------------------ColumnComment-----------------------------
[if exists (select 1
            from  sys.extended_propertIEs
           where  major_ID= object_ID('[%QUAliFIER%]%table%')
            and   value = [%r%?[N]]%.q:COMMENT%)
begin
   [%OWNER%?[.O:[execute ][exec ]]sp_dropextendedproperty [%r%?[N]]'MS_Description',[%r%?[N]]%.q:table%,[%r%?[N]]'column',[%r%?[N]]%.q:ColUMN%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_dropextendedproperty [%r%?[N]]'MS_Description',[%r%?[N]]%.q:ColUMN%
]


end




][%OWNER%?[.O:[execute ][exec ]]sp_addextendedproperty [%r%?[N]]'MS_Description',
   [%r%?[N]]'user',[%r%?[N]]%.q:ColUMN%
:select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_addextendedproperty [%r%?[N]]'MS_Description',[%r%?[N]]%.q:ColUMN%

]

视图改动如下：

原先的脚本：

[if exists (select 1
            from  syspropertIEs
           where  ID = object_ID('[%QUAliFIER%]%VIEW%')
            and   type = 3)
begin
   [%OWNER%?[.O:[execute ][exec ]]sp_dropextendedproperty [%r%?[N]]'MS_Description', 
   [%r%?[N]]'user',[%r%?[N]]%.q:VIEW%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_dropextendedproperty [%r%?[N]]'MS_Description',[%r%?[N]]'vIEw',[%r%?[N]]%.q:VIEW%
]
end




][%OWNER%?[.O:[execute ][exec ]]sp_addextendedproperty [%r%?[N]]'MS_Description', 
   [%r%?[N]]%.q:COMMENT%,[%r%?[N]]%.q:VIEW%
:select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_addextendedproperty [%r%?[N]]'MS_Description',[%r%?[N]]%.q:VIEW%
]

改为：

[if exists (select 1             from  sys.extended_propertIEs            where  major_ID = object_ID('[%QUAliFIER%]%VIEW%')             and   minor_ID = 3)

总结

以上是内存溢出为你收集整理的PowerDeisnger16下导出到sqlserver2005以上出现sysproperties错误的解决办法全部内容，希望文章能够帮你解决PowerDeisnger16下导出到sqlserver2005以上出现sysproperties错误的解决办法所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。