Hmmm... I am not sure why you can't see master.dbo.sysdatases. The table does exist although in 2005 and 2008 they hide it and you use mater.sys.databases (a view) instead....

Last update. It now has defaults on all parameters. Also you can tell it to change ownership on objects owned by orphaned users.

Enjoy.

Yes. Whew! 🙂

Thanks so much for your help. And yes, I am in the process of upgrading my SQL 2000 databases to 2008. Fortunately all of these databases except one...

I have found through my own experience that removing users that own objects will cause problems... like you can't get to the objects anymore. I fixed this in the...

Oh... I should read your whole post. I was thinking I could re-assign the tables in question to another uid in sysobjects, or simply remove them. The latter...

Ummm... yeah *looks around sheepishly* Me.

Yep, you got me! Good catch. At least I know what I have done wrong and how to fix it. Thanks.

D'oh! One more fix. The line:

IF @SvrLevel NOT IN ('90','10')

Should be:

IF @SvrLevel NOT IN ('9.','10')

I will fix and submit.

🙂

Yes I have seen that. What is happening is the procedure is at the point where it is either trying to fix a lost or orphaned user and it...

I cut and pasted the script from the listing and I got the same errors. I went through and replaced all the white space (tabs, spaces etc.) at the...

Yes, I do have an update. I have posted it but so far I have not seen my changes show up on the website. It now handles read...

Thanks Flar, I had already stumbled upon the requirement for the brackets on the database names when I ran this script on one of my older database servers. I...

Geez, that was simple. And what bothers me is as soon as I read your post I thought 'I knew that!' I was in too much of a...