The length of time between releases is not a major thing with me or my organization especially if you have a product that works and SQL Server 2000 does just...

I lived in CA for many years and was delighted to see alternate options such as geothermal, wind, and sun being utilized and explored. There are some truly great ideas...

Great article Steve! The line of questioning was solid and I liked the fact that it was not just focused on their product line. I have been fortunate enough...

You didn't just install any of the 2005 tools on that machine did you? I know where I have the 2005 tools the database listing expands really slowly. Curious.

Amy,

Using the mail task in DTS can be somewhat odd in that if you add the task while developing from your PC then it will use your Outlook mail profile...

You can also log onto the server, open Windows Task Manager, go to the processes tab, find the dtsrun.exe process and end that process. That will also clear up the...

Edit your maintenance plan for log shipping, select the log shipping tab, click on the destination server and select edit, select thresholds tab, and change the load time delay to...

This link will give you the information you need.

http://support.microsoft.com/default.aspx?scid=kb;en-us;303774&Product=sql2k

David

Thanks Brian! I was going down that road and have had good success querying Active Directory from SQL Server in the past but was hoping that I could find something...

You might also take a look at "Maximum Capacity Specifications" in SQL Server Books On Line....

David

As far as I know there is nothing that will truly "load-balance" a SQL Server installation. You can have an Active / Active cluster solution where you split the heavily...

Ahhh. dbo is a standard user in every database. If you were to go to the security, logins view and double click on sa you would see that under the...

I'm still trying to decipher all this but where is the join specification for your first derived table A2.something = A3.something.

Sorry if I missed it but I just don't...

Not sure I get everything you are saying but the login sa usually translates to database user dbo.

I would not delete dbo as a user from the database. Not...

Triggers is definitely an option. I personally am not a fan of triggers but that is one of the best purposes for them.

Another option is to build in this...