Tag: mssql
Browse the blog by topic.
3 posts · All tags
-
MSSQL Emergency Mode
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 'all...
-
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...
-
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...