1 clustered 2000 to be upgraded to 2K5 soon, 1 development, 1 test, about 8-10 other productional ones all SQL 2000 for and a single one upgraded to 2K5.

what is your development environment?

By the way, is your box's RAM is higher than 2 Gigs? Then you need to apply another patch (http://support.microsoft.com/default.aspx?kbid=899761) otherwise you will not able to use full...

Really interesting. I found this blog via int. Check if it's yours or not. I'll keep looking an eye on that and maybe others in this forum know another think...

Thanks Wesley, I didn't know that

But that info just displays the general statement (create, alter for instance) but it does not display what really happened to a table or...

We have not experienced any performance issues after SP4. What is the possible bottleneck that you are experiencing? Perfmon comments etc?

You cannot find that information in sysobjects table. But if you need to keep track of the objects that are changed you can set a DDL trigger. When any objects...

In cluster environment for the disk resources that are need to be accessed by the SQL service on the cluster, you need to define a "resource" on the cluster. In...

Actually I do too more than just DBA jobs. I think wearing a lot of hats is good in some sense but it prevents you from being an expert on a...

Yes Dinakar, it is not possible to get the current LSN while db is in "restoring" mode. (at least I couldn't get it so far

Great!

Hi Dave,

Why do you need to use SQL Mail? We in our shop used to have SQL Mail but most completely get rid of it because of this kind of...

Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name. Make sure that the name is entered correctly.

Is that the error you are...

Do your apps connect to the sql cluster via NT Auth?

Do your apps connect to the sql cluster via NT Auth?