Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem generating SQL Scripts

Status
Not open for further replies.

ChrisQuick

Programmer
Oct 4, 1999
144
US
I have a bunch of stored procedures in a database call it ABC.

When I hightlight one or more stored procedure names in ABC and right-click and go to Generate SQL scripts from it I get the error: "csquick is not a valid user in database "XYZ".

I am not trying to script anything from the other database.. Is this a know bug with SQL Server 7.0? cquick@callingpost.com
Geographic Information System (GIS), ASP, some Oracle
 
My guess would be that one of the stored procedures you are scripting, accesses some object in database xyz.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top