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 |
|
vlfoley
Starting Member
6 Posts |
 Posted - 2011-05-31 : 12:54:18
|
| i am going to run a simple query to count active users in a database. thie results of this query are going to be stored in another database table. i need to use the 'use' clause in order to make this completely automatic and switch between available databases. i have no clue how to write the insert and update statements to bring the info into the table to save it or how to use the 'use' cluase. any ideas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-06-01 : 00:13:06
|
| try using linked server... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
vlfoley
Starting Member
6 Posts |
Posted - 2011-06-01 : 07:43:18
|
| We have a seperate database for each client and I need to count the users for each client. The databases are on different servers, not a seperate server for each database but several databases lumped together on one server. 10 databases on a server, 10 on another, like that. |
|
|
|
|
|
|
Variables and the use clause