Thanks. I do have the scripts needed to create the missing procs already. The main concern I have is why they are missing in the first place. Am I to...

Although I don't have a satisfactory explanation of "why", I have found one. I'm posting this in case anyone else has this same error and runs across this thread....

Yes, it occurs every time I log in as sa. I have a query window open and select change selection. When I enter sa and the password the query window...

Hmm. There is no active testing or development going on with the DBs on this server. Any suggestions on where I can narrow down potential sources? Don't see...

My coworker tried creating a new dataset and this did not resolve the issue. For the question about the database, yes, that was one of the first things we...

I don't believe it was new. A colleague of mine is working on this so I will check with her. But I believe she imported the report (moving...

Hmm. No responses yet. Well, I kept poking around on Google and have stumbled upon my answer. I'll post it here in case anybody else has this same issue and...

thanks

Was there any resolution to this? I'm getting this same error message :crazy:. I recently installed 2008 R2 on a server and today I was about to start...

Incredibly Fantastic! 😉

Thanks! I'll try that.

Now, the funny part... as soon as I hit post I got this "crazy" idea to check profiler. Of course, as soon as I did I found...

I actually just went ahead and rewrote the query anyway for some performance improvements. Then I was planning to take some steps similar to what you suggested the next...

No, I'm not sure why the original developer chose to do it that way. Perhaps for simplicity (personal sanity) since the logic they used to determine the oneYrActList is quite...

I followed the Amazon links for the books. Thanks!

-mia

Hmm. Well, now I feel better since it's not just me!

I did find a little relief. I answered one of the SQL Server Stumper questions (from the banner...