In my dev environments sometimes I don't exactly bother with getting all of the requirements in place and lots of times I get away with that and other times it just bites me in the butt. Case in point: I'm upgrading a db that's 15.1.2.4962 to 15.1.2.5184 just in my dev environment.
The client still uses SQL 2000 so that's what I use in this vm and I had it only at service pack 3 despite the fact it's documented by ASI that you should be at sp 4.
So does it matter? Yes! Without sp 4 in place you will see this error when the db upgrade utility runs:
*** ERROR creating stored procedures ***
Could not find database ID 102. Database may not be activated yet or may be in transition.
Msg 913, Level 16, State 8, Server VM01, Line 71
Luckily for me, there's always Google.
Here's the Microsoft KB article that explains the problem you run into: "You may receive a 913 error message if your query includes user-defined functions, derived tables, and JOINs." And of course the answer is to put service pack 4 on like I should have in the first place.
Comments