[收藏]MSSQL数据库变为单用户问题解决
USE master; GO DECLARE @SQL VARCHAR(MAX); SET @SQL='' SE...
扫描右侧二维码阅读全文
17
2009/07

[收藏]MSSQL数据库变为单用户问题解决

USE master; GO DECLARE @SQL VARCHAR(MAX); SET @SQL='' SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID) FROM master..sysprocesses WHERE dbid=DB_ID('WebMedia7'); EXEC(@SQL); GO ALTER DATABASE WebMedia7 SET MULTIUSER;

Last modification:November 26th, 2018 at 04:16 pm
If you think my article is useful to you, please feel free to appreciate

2 comments

  1. Johnny Woo

    抱歉,暂时木有...呵呵

  2. ISNULL

    有没有查找表中主外键字段的代码啊。。。

Leave a Comment