Can you change the database on the fly?
In the connection string you've got "database=Company1"
so with an open database connection, from
Code:
get SQLConnectionId of oConnection sId to hDBC
Is there a way to switch the database on the fly? I need to update a function, stored in the company2 database, and you cant use
Code:
use company2;
alter funtction fooTest...;
because "alter" must be the first statement in a batch.
I can see the hard way to do this, but I'm wondering is there a simple way to effectivly send the "use NewDatabase" command in the SQL?
Michael Mullan.
Danes Bridge Enterprises.
++++++++++++++++++++++++++++
There is just today. Tomorrow is a concept
that is mostly theoretical. -- GM Wylie
++++++++++++++++++++++++++++