There are a few undocumented things about the MSSQL Server 2000 missing in the knowledgebase of Microsoft. That’s a way to get a database marked as suspect into emergency mode: use[master] go execute sp_configure ‘allow updates’,1 reconfigure with override go update sysdatabases set status =32768 where name =” go
Tag: database
MS-SQL Recovery
There are two kinds of customers: The ones who do backups and those who didn’t have data loss yet, ignoring all good advice and best practices. However, in the end it’s always us, the IT crowd being yelled for to look at the shards and doing a miracle. A broken database at the MSSQL server is marked as […]
Who’s connected to my MSSQL server?
Today I was trying to restore a backup of our MSSQL server when a user decided to drive me crazy by not disconnecting after telling anyone that we need to do that restore. So I fired up the management studio and had a look at the current processes by using the following query: select spid, status, loginame, hostname, […]