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 |
|
dylanmendes
Starting Member
7 Posts |
 Posted - 2005-05-30 : 09:55:48
|
| Hello,I have a peculiar requirement.. or so I think. I need to work with two different databases (let's say master and NorthWind) within a stored procedure saved on, say again.. Northwind.When I tried putting "use master" and "use Northwind" within the stored procedure, I received an error telling me that this cannot be done within stored procs/triggers. Is there anyway I can workaround this to accomplish my task? Please help...Dylan |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-30 : 09:59:40
|
| Instead of Use NorthWindSelect columns from table try to use Select columns from Northwind..tableMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
HELP: "use <database>" within stored proc