I'd agree with Scott, detach then attach.

It is supposed to end Apr 8, 2008, but Microsoft has typically supported 2 versions at any one time. With SS2K8 not being released until Q3, I'd guess that support...

I just got a Toshiba Qosmio, Dual Core, 2.4, 2GB RAM, 200GB disk, around US $1600. Not sure what that would be in UK.

Works well, fairly quick, but no XP...

In your example, that is a column name you're using in an update statement, not a table name.

You cannot dynamically set tables in a DML statement like

select * from @mytable

or...

No, it's not tracked.

You can profile all your queries and do some heavy duty analysis, but there's no other way to tell.

Good feedback and glad you're not afraid of giving it here! 🙂

Andy has a good point in that executives don't want to share until they've already decided, and what's the...

SQLAgent should be dependent on SQL Server. If it's not, then it might be trying to connect before SQL Server itself is up.

You can try changing the SQLAgent account in...

Both of the last two suggestions are what I'd recommend. Rebuild indexes, if that doesn't help, consider using a higher sample rate with update statistics.

I haven't seen that before and it's no used in normal querying. My guess is it's something used internally by SQL Server.

Also, I never use dump devices. It's held over...

You can't give her a local copy of the DB? Disk is very, very cheap now. US$1000 for 1TB.

If not, there's no good resource governer in 2005 other than Gail's...

you can always set an alert if the db size "exceeds" the current size. Databasess Object.

First, please post in the version appropriate area. This was in 2000, I'll move to 2005.

Second, I'm assuming there is no connectivity, so some manual method is needed to move...

Have you profiled if anything else is happening or is this from a trace?

Why kill SPID2 if it's blocked by 1? Or am I not understanding. It would appear that...

Here is a KB for setting up mail and a few issues:

http://www.sqlservercentral.com/articles/Administering/sqlmailresources/605/

Walk through the procedure from MS exactly.

You have to loop somewhere, either in the client code or the stored procedure code. There's no good way to split the string up and insert the values in one...