Can I rename an instance of SQL Server after I have already installed it on the computer? Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by
Read More...
Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,
Read More...
While installing SQL Server Express 2005 you might have come across the error: System Configuration Checker Fails with "Performance Monitor Counter Check Failed" Message As you have seen that one of the README file for SQL 2005 installation suggests the
Read More...
You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that
Read More...