That worked. Also, if you create a SQL Agent job, the domain account for the SQL Agent needs correct permissions in 2008 to execute any stored procedures used in...

Wow! That appears to have worked. I ran the script the 1st time and it didn't prompt for the Instance, just ran with the default Instance. Ran...

First time posting this type of info. Wasn't sure if I should provide the computer, domain or user specific info, so I replaced with <#####>. Hope this helps.

Same...

Awesome.

I'll give it a try.

Thanks

CSC

Can I change the model to FULL?  If yes, are there any side effects?

Database was initially created in MSDE, so the default model is SIMPLE.  Evidentally, the setting stayed the same,...

Thanks for the explanation.  I like the approach and will look into it.

Greg and Kemp

Thanks for the replies.  I have it working by using the VIEW suggestion made by Kemp.  It adds more thought to the User/Roles part of the databases, but...

Thanks for the clarification.

PNParent is varchar in all the SQL tables where it is used.  I got sloppy with the ADO datatype and used adChar instead of adVarChar on a...