I need to move some databases to a new drive but there is no management
studio on the server.

It is SBS R2 with SQL 2005 workgroup edition

What to do ?

Jack

Go to a command prompt and type sqlwb.exe
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

SSMS (and other 'client tools') may not have been installed on the server.

Use the SQL Server installation disk, and select 'Install Client Tools'.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


[quoted text, click to view]