Setting default database in Stored Procedure.

[CapsuleCorpJX]

In a stored procedure, I tried using:

DATABASE <database name>

But it wouldn't work.

It does work when I'm using the statement outside of a stored procedure.

Is there a work around or an equiv statment?

 

[dnoeth]

DATABASE is unsupported syntax in SPs, but you can fully qualify table names, e.g. databasename.tablename.

If object names are not qualified the default database at the time when the SP was created is used.

Dieter