Ok, I have the database, and I have the data, but I am missing the stored procedures and functions.

What scripting options do I need to choose to get those?

Thank...

Ok update. I did the initial blank create of the database in sql 2005, then ran the scripts to build the table structure / roles / etc, without the data....

I tried making security changes to the file with no luck on the access denied error.

I did try scripting just the database, and trying to get the structure to...

Sadly there are no other errors.

The generate script runs perfect no errors, creates the script clean. I take the file which is saved, push it up to the server....