Mega Code Archive

 

Categories / MSSQL Tutorial / Database

 

Changes the user access option of the pubs database to SINGLE_USER and generates an error if any other connections to the pubs da

ALTER DATABASE pubs SET SINGLE_USER WITH NO_WAIT