摘要：sp_dropserver 'oldname'sp_addserver 'newname','local',null 阅读全文

摘要：select object_name(id)tablename,8*reserved/1024 reserved,rtrim(8*dpages/1024)+'Mb' used,8*(reserved-dpages)/1024unused,8*dpages/1024-rows/1024*minlen/1024 free,rows,* from sysindexeswhere indid=1 阅读全文

摘要：Declare @str varchar(100)set @str='' --需要检索的字段declare @s varchar(8000)declare tb cursor local forselect s='if exists(select 1 from['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'')print ''所在的表及字段:['... 阅读全文