I am afraid that I may have to rebuild.

Is it possible to get the msdb database FILE from a backup of 2 weeks ago and apply that file to the...

Thank you.

The mssqlserver service had stopped and sqlagent service has disappeared. All this happened before the reboot. I was installing Office 2K at the time. I...

I see this in system logs, but nothing in app logs. Is it telling me that I should reinstall sql server?

Application popup: SQL Server : SQL Server could...

We are moving the "create index" statements to another stored procedure and which we will call from the original SP. I am not sure if this will work, but...

Thanks for the reply. You are right, I didn't read the article thoroughly. Installing the SQL 2005 CTP did the trick. Thanks again.

I had the same problem once and changed from 10% to 20% and it did not revert back.

Hi Allen, thank you for your help on this.

I see a lot of PAGEIO_LATCH waittypes on this server in particular. Yesterday I saw the page split counter go in...

Thanks everyone for ur help on this.

Thank you very much Scott.

I was wondering the same thing about tempdb. If the tempdb has more than one data file, and there are multiple transactions on the database...

Wow, thank you for that tool! It turly is a great tool. Thanks a million.

Thank you very much for your help! We will re-write the SP and creat the table outside of the SP and grant the right permissions. Thanks again.

Hi everyone,

Both are SQL 2K on Win 2K and both SQL and Win have the latest patches applied.

Both SQL databases have the same startup account, which is a domain user...

Hi Vidas,

I just tried it again on my server and it is not doing it. I added myself to the local admin group and reconnected to my server through...

Hi everyone,

I am a system admin on that database server and I have the same permissions as I do on the other server. I am also a member of...

Thanks for the info everyone! Very helpful.