Warm weather in the Midwest can't be far off now......

The big question: Will Albert P. sign a big long term deal with the Cardinals before the Wednesday deadline.

That should be OK. Restarting or failing over one instance from one server to another won't effect the others. Keep in mind you will need enough CPU and...

We have so many SQL Servers here we would have to have a team of DBAs and Application folks simply dedicated to keeping up with SQL Server new versions. ...

I found the answer on another forum.... You have to stop and start SQL Server Agent. Mail now sends!

Geoff A: Thanks... It was not enabled. I enabled it but still nothing.

I queried the table you listed and the table is empty.

Yes, nothing stands out as an error.

I found it. ADD OPERATOR.

GilaMonster (2/3/2011)

---

Yes, sysindexes is a system table, but my post doesn't say to drop indexes off of a system table. Sysindexes contains all indexes and so in general the fix...

Yes. Restoring MSDB database will get you all of your SQLAgent jobs. Keep in mind if you attempt to restore MSDB the SQL ServerAgent service has to be...

Here is the output.

Table error: Object ID 2. The text, ntext, or image node at page (1:87), slot 7, text ID 95630196736 is not referenced.

CHECKDB found 0 allocation errors and...

Great link, however, if I follow the link and attempt to do it it won't work because the index is on a system table and when you try and drop...

I found another db that we inherited and no one had a CHECKDB scheduled. I ran it on this db and found this error:

Server: Msg 8964, Level 16, State...

I try and do this after a patch or when I know I have an outage window. It is always good to have an easy way to get SQL...

Thanks. I am going to have the server engineer team runs some diagnostics on the server to make sure everything checks out OK.

Thanks for your quick reply. However, I ran a rebuild all indexes and DBCC CHECK DB and it came back with zero errors now.