DO NOT SHRINK databases. This messes with your indexes and increases fragmentation.

You need to have free space in your database. As people add data or change it, there should be...

How are you exporting in the job? Meaning what's being run?

DTS would make this easy. You can use the data export wizard to help set this up from Enterprise Manager.

Look up dateadd in BOL for the syntax.

Most of these are system stored procedures.

First, don't allow guest or others into msdb, and you can ignore the public permissions there. If a user doesn't have access to the...

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.