USE When DB Name Not Known In Advance

NOTE: I am using MS-SQL 2K

I have a SQL script that needs to change from a particular DB to the Master DB (to grant EXECUTE permissions to a few SPs in the Master DB), then change back to the original DB. I will not know at design time what the DB name is.

What I am trying to do is something like this:


Use Master
GO
Grant EXECUTE on sp_OACreate TO C2SRolePowerUsers
GO
Declare @DBName varchar(32)
EXECUTE xp_instance_regread 'HKEY_LOCAL_MACHINE', 'SOFTWAREODBCODBC.iniMyDSNName', 'Database', @param = @DBName OUTPUT
Use @DBName
GO


The problems:

1) I have to do this in a single pass using ADO and the script. The reason is that it is part of a generic routine, looping through a list off commands, and cannot perform one command, change the DB reference via ADO, then change back in separate ADO commands.

2) It fails on the second USE command.

I have looked to see if there is some sort of "EVAL()" function, or a stored procedure to change the current DB. No luck.

Any suggestions?

Thanks,


__________________
Bob Rouse
Comsquared, Inc.