Ramblings of a DBA

Tara Kizer
posts - 166, comments - 837, trackbacks - 75

My Links



Search this Blog


Post Categories


June 2006 Blog Posts

Red Gate Software

Last week, I received a new laptop.  For the past few days, I've been installing all of the applications that I need.  Today, I decided to tackle Red Gate's SQL Compare.  On my old laptop, I was running version 3.  I hadn't kept a copy of the installation, so I went to their site to see if I could download it.  I couldn't find version 3, so I decided to download the new version to see if my serial number would work as I wasn't sure if we had renewed our support contract.  My serial number didn't work in version...

posted @ Tuesday, June 20, 2006 4:02 PM | Feedback (2) | Filed Under [ SQL Server - General ]

SQL Debugging in SQL Server 2005

Some of our developers regularly debug stored procedures in SQL Server 2000.  In fact, they can't live without it.  The next version of their application will use SQL Server 2005. Today, one of the developers asked me how to use SQL Debugging in SQL Server 2005.  I barely even know how to use it SQL Server 2000, but I wanted to help him so I started reading about it on MSDN. In SQL Server 2000, I had to grant execute permission on master.dbo.sp_sdidebug extended stored procedure in order for them to debug T-SQL code.  According to this article, the connection account must...

posted @ Thursday, June 08, 2006 3:45 PM | Feedback (5) | Filed Under [ SQL Server - General ]

SQL Server 2005 instance number

If you've installed multiple instances of SQL Server 2005 on the same database server, perhaps you've noticed Microsoft's naming convention for the file locations.  They are now using MSSQL.n, where n is the instance number.  We have 4 instances installed on a database server.  One of them is the default instance; the other 3 are named instances.  Here is what our directory structure looks like:E:\MSSQL.1\MSSQL\... E:\MSSQL.2\MSSQL\... E:\MSSQL.3\MSSQL\... E:\MSSQL.4\MSSQL\... This quote, from this article, explains the naming convention: The first instance ID generated is MSSQL.1; ID numbers are incremented for additional instances as MSSQL.2, MSSQL.3, and so on. If gaps occur in the ID sequence due to...

posted @ Wednesday, June 07, 2006 12:59 PM | Feedback (9) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET