I have 2 SQL instances - x1 SQL 2000 and x1 SQL 2005.
Each instance has about 100 databases in it.
I need a way to quickly take all the databases offline.
I have tried the query:
ALTER DATABASE database-name SET OFFLINE WITH NO_WAIT
However, this only takes the individual database offline. I would like a way to take all the databases in an instance offline from a script.
Is this possible?