At present we don't use Crystal Reports, but I have heard of it. What are foobar queries and was it easy to stop them (such as with a change...

Thanks! I just read the article and plan to experiment in our development environment.

Robert Marda

I know almost nothing about ADO unless using an Active Script Task using ActiveX to create a connection counts as ADO. I also know very little about ActiveX. ...

This heartbeat check program you developed. Is it just a simple program or is it something complex. Our network people have something set up to detect if a...

These may be out of your price range, but I'll mention them just in case.

We used Exodus to host our SQL Servers and web servers until they ran into financial...

I am beginning to see that. I went back and looked briefly at all the responses and it seems only about 3 people started out working with databases. ...

Thank you all for your responses. I'm going to try using them soon as we are getting enough deadlocks that it would be nice to know more about what...

Thanks! I'm glad you liked it. My goal is to deliver information that is useful in an easy to understand way. If I succeed in this then...

I want to thank everyone that has posted to this thread. Your comments help to resolve my curiousity about how people become DBA's and to let me know I'm...

This article was interesting to me. I have gotten the error when creating tables, however when I create a table in SQL Server 7.0 it lets me even though...

For moving DTS packages that only apply to one databse the best way I know is to open each DTS package and save it on the new server. Then...

Excellent! That works and eliminates the need for a derived table in the first example I used in my article. I wish I saw that before writing my...

I like the sound of that fault tolerant set up and it could be all you need to ensure their are no failures during working hours.

As for testing and...

I have never had to do this, but I think you can just copy a backup of msdb and restore it on the new server.

Robert Marda

Yes, derived tables require more memory than temp tables or possibly other ways to get the same reults. With enough memory you can take advantage of the derived tables...