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 |
|
Jim Beam
Posting Yak Master
137 Posts |
 Posted - 2011-01-05 : 12:17:12
|
| Hi all,In what situations would you typically find multiple instances of SQL on the same machine, and why? Cheers,Jim. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-01-05 : 12:23:57
|
| Separation?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-05 : 12:26:54
|
| We have several servers in our dev and testing environments with multiple instances. One reason is to test replication, or apps that depend on replication. Another is to mimic some of our production environments with minimal hardware. |
|
|
|
|
|
|
Multiple instances