View Single Post
Old 12-13-2006, 02:53 PM   #3
socalwingfan
Retired
 
socalwingfan's Avatar
 
Join Date: May 2004
Location: Pacific Ocean
Exp:
Default

If it is a single file database you can use:

EXEC sp_attach_single_file_db @dbname = 'xxx',
@physname = 'c:\Data\gp.mdf'
socalwingfan is offline   Reply With Quote