摘要: /* 打开修改系统表的开关 */sp_configure 'allow updates', 1RECONFIGURE WITH OVERRIDE存储过程如下:create procedure sp_droplogin@loginame sysnameas declare @exec_stmt nva... 阅读全文
posted @ 2014-07-10 10:50 濤叔 阅读(2680) 评论(0) 推荐(0) 编辑
摘要: EXEC sp_password NULL, 'NewPassword', 'Sa' 阅读全文
posted @ 2014-07-10 10:01 濤叔 阅读(198) 评论(0) 推荐(0) 编辑
摘要: create procedure sp_password @old sysname = NULL, -- the old (current) password @new sysname, -- the new password @login... 阅读全文
posted @ 2014-07-10 10:00 濤叔 阅读(1439) 评论(0) 推荐(0) 编辑