摘要: 批量导出索引： SELECT'CREATEINDEX'+[name]+'ON['+OBJECT_NAME(object_id)+']('+REVERSE(SUBSTRING(REVERSE((SELECTname+CASEWHENsc.is_descending_key=1THEN'DESC'ELSE'ASC'END+','FROMsys.index_columnsscJOINsys.columnscONsc.object_id=c.object_idANDsc.column_id=c.column
阅读全文
摘要: 一台SQL Server的磁盘空间不够备份，想做日志传送，无法实现，在网上找了一个方法 原文URL： http://blog.sina.com.cn/s/blog_4c8f1ac20100rz7z.html sp_configure'showadvancedoptions',1;GORECONFIGURE;GOsp_configure'xp_cmdshell',1;GORECONFIGURE;GOsp_configure'showadvancedoptions',0;GORECONFIGURE;GOexecmaster..xp_cmdshell&
阅读全文