Extracting SQL database to SQL script

having trouble executing script to new database

[scott859]

Greetings,

I have extracted a SQL Server 2000 database for a client to a sql script via a free enterprise manager program called SQL Manager.

SQL manager tells me that the script has been successfully created. I extracted the structure and content into one script.

My intent was/is to populate the new database (on a new server - my client is changing hosting companies).

For some reason I keep getting an error stating that I do not have "permission to preform this procedure" when attempting to execute the script on the new server/database.

The new hosting company is Verio and they have been of no help. They maintain it must be the script that is fauly, but won't give me any insight into what could be wrong beyond that.

If anyone can lend some insight into this it would be greatly appreciated.

Thanks in advance.

Scott

[syber]

If you are installing the script on another server, you will need CREATE permissions for that specific database. This could be the source of your problem.