摘要：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 阅读全文

摘要：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... 阅读全文

摘要：直接运行以下script：sp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'clr enabled', 1;GORECONFIGURE; 阅读全文