Until 2012, all of the previous versions of MS SQL kept the user info in the master DB. If you restore a DB to another server, those User IDs will...

OK... final update!!!

I dropped and recreated the three SPs only. I then re-ran the maintenance to see if those three errors were gone. When the maintenance ran, it had a...

Three of them are and I am doing that right now.

The one is a table...

Ugh... that is not good....

Thank you for the fast help!

I ran the query in the database that has the problem and got this result back;

SELECT Object_Name(16823222)

go

U_updateBOUserPhoneNumber

SELECT Object_Name(16055143)

go

U_Phone_Number

SELECT Object_Name(32823279)

go

U_updateSitePhoneNumber

SELECT Object_Name(48823336)

go

U_updateUserPhoneNumber

Greg Charles (4/15/2009)

---

I'm not aware of a way to automatically connect to servers when SSMS is opened. You can save servers in the Registered Servers window, but you still...

Hey Paul,

Sorry for the late reply, but the hot fix worked. After I installed it and re-ran the maintenance, I found two databases that had corruption. One seemed to have...

Thanks Paul,

As I was downloading the patch, I see that SP3 is out there. What do you think of that? Has there been any issues with that patch? Would...

Hey...

Paul Randal (4/13/2009)

---

Should be somewhere in there - can you post the error log? (Or just email it to me - paul@sqlskills.com).

It's entirely possible (and likely) that the error...

Paul Randal (4/13/2009)

---

This error and state indicates that you've got missing information in one of the system tables in a database (i.e. metadata corruption). In the SQL Server error log...