Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MarkyBoy666
Starting Member
14 Posts |
 Posted - 2004-12-17 : 05:51:56
|
| Hi,Quick question...I'm using the following exec statement:exec ('use dblive; exec sp_pkeys '+ @tab)What I want to check is, will the 'use' command set dblive as the default database for the rest of the procedure, or only for the duration of the exec statement (which is what I want)?Many thanks!!! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-12-17 : 06:14:06
|
only for the duration of the statement.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Specifying database