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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment