I took some database from mproduction, updated and then restored to acceptance. I was trying to make my update as quick as possible so I dropped my originals and renamed my new ones...
now I am getting this...
"Could not find database ID"
I have looked at a few things like ...
http://msdn2.microsoft.com/en-us/library/Aa258743(SQL.80).aspx
but it ain't working and I have not been able to find the crossdatabase referencing object causing all of this pain using profiler and the QA.
it's probably not a good idea to update the key on sysdatabases in master. anyone got any bright ideas.Just run DBCC FREEPROCCACHE. There is a plan in memory that is based on the prior database ID of the database. Once that is gone, you should have no problems.|||thanks. that did it. too much excitement for a monday morning. now I am crashing from my adrenaline rush.
Showing posts with label mproduction. Show all posts
Showing posts with label mproduction. Show all posts
Wednesday, March 7, 2012
Could not find database ID...
Subscribe to:
Posts (Atom)