随笔分类 -  SQL

摘要:Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support o 阅读全文
posted @ 2013-07-16 00:23 terryxym 阅读(283) 评论(0) 推荐(0)
摘要:USE MASTER DECLARE @i INT SELECT @i=1 DECLARE @sSPID VARCHAR(100)DECLARE KILL_CUR SCROLL CURSOR FOR SELECT SPID FROM sysprocesses WHERE DBID=DB_ID('数据库名') OPEN KILL_CUR IF @@CURSOR_ROWS=0 GOTO END_KILL_CUR FETCH FIRST FROM KILL_CUR INTO @sSPID EXEC('KILL '+@sSPID) PRIN... 阅读全文
posted @ 2012-12-18 15:21 terryxym 阅读(403) 评论(0) 推荐(0)
摘要:直接运行以下script:sp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'clr enabled', 1;GORECONFIGURE; 阅读全文
posted @ 2012-12-18 11:44 terryxym 阅读(321) 评论(0) 推荐(0)