Can I change the database context in a script procedure?

Inside a script executed in context of database A, I want to create a table in another
database B for example.

Thanks.

Dan,

> Can I change the database context in a script procedure?

In a script, yes; in a stored procedure, no.

> Inside a script executed in context of database A, I want to create a
> table in another
> database B for example.

In a script or job, you can close the currently opened databse and open a
new one with the USE statement, like this:

 ...
 USE B;
 EXECUTE IMMEDIATE 'CREATE TABLE X .... ';
 USE A;
 ...

--
Fernando Dias
[Team Elevate]