sqlcmd -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
ALTER DATABASE SUSDB SET SINGLE_USER WITH NO_WAIT
DBCC CHECKDB
go
If the about command cannot fix, try this one but will have data loss
DBCC checkdb ('SUSDB', repair_allow_data_loss)
Finally,
ALTER DATABASE SUSDB SET MULTI_USER WITH NO_WAIT
go
Nice article - straight to the point!
ReplyDeleteJay.
I get a named pipes provider issue.
ReplyDeleteyou have to check the correct DB to connect first
ReplyDelete