Shulou(Shulou.com)05/31 Report--

This article mainly introduces the database readonly how to do, the article is very detailed, has a certain reference value, interested friends must read it!

The usual practice on the Internet

USE master

GO

DECLARE @ SQL VARCHAR (MAX)

SET @ SQL=''

SELECT @ SQL=@SQL+'; KILL'+ RTRIM (SPID)

FROM master..sysprocesses

WHERE dbid=DB_ID ('datayesdb')

EXEC (@ SQL)

GO

ALTER DATABASE [datayesdb] SET MULTI_USER

The above method didn't work, and then I finally got it with the help of lg. I was scared to death.

Set deadlock_priority high

Alter database [datayesdb] set offline with rollback immediate

Set deadlock_priority high

Alter database [datayesdb] set online with rollback immediate

Set deadlock_priority high

Alter database [datayesdb] set multi_user with rollback immediate

The above is all the contents of this article "how to do Database readonly". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.