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: mssql
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 […]
MSSQL vs Access via JET/ODBC
If you are dealing with a greater amount of records in a Microsoft Access database, it’s recommended to use a SQL server as a backend database to handle those and get rid of unpleasant surprises. Usually those servers are connected via JET/ODBC – and that’s where the fun starts.