Category: Database
How to find the service pack version installed on SQL Server
Run and execute the following query; it doesn’t matter what database and/or table you’re in: select @@VERSION If executed successfully, you should get something like below, which shows that SP2 is installed. Microsoft SQL Server 2005 – 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build…
Resetting Primary Key counter in SQL Server
To reseed/reset the IDENTITY column of an SQL Server table, run the following in Query Analyzer or SQL Server Management Studio: DBCC CHECKIDENT (Table_Name, RESEED, 1) Peace!
Auto backup solution for your MySQL databases
I use MySQL as my database server, and thankfully, it’s been reliable and easy to use. A qualm I have, however, is that it doesn’t include a daily backup feature, unlike Microsoft SQL Server. The good thing is that the open source community has seen this problem and created a solution for it: AutoMySQLBackup. (You can…