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 |
|
gsrinivas.
Yak Posting Veteran
56 Posts |
 Posted - 2008-10-26 : 04:07:40
|
| for example "mydb1" and "mydb2" are separate databases in sqlserver2005.hear my doubt is how can i use perticular database dynamically...my idea is "write a stored proc and pass inputstring to that"can any one implement that please..... |
|
|
malaytech2008
Yak Posting Veteran
95 Posts |
Posted - 2008-10-26 : 05:58:11
|
| Can u please give more information in what situation u need that and what kind information u want to pull from the DB.malay |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-26 : 07:00:09
|
| if you attempt is to run query on multiple databases the best method is to use undocumented stored procedure sp_Msforeachdb. refer below linkhttp://www.databasejournal.com/features/mssql/article.php/3441031 |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
How can I use database dynamically