Chris writes "Does SQL need to have the server running in order to access the database? I uploaded the two files, AZWD.MDF and AZWD.LDF to a root directory in a website. Is there a way to connect to them without them having to be in a directory: C:\Program Files\Microsoft SQL Server\MSSQL\Data?
The database engine of the instance has to be running for you to acces the contents of the Server. The MDF and LDF don't have to be in the "C:\Program Files\..." folder they can be anywhere but they must be attached to that instance.
quote: Also look for sp_attach_db in SQL Server help file BOL
BOL is always a good place to start...
Regards N
If you want your computer to be faster then throw it out of the window.
Is there a way.
Posted - 01/09/2006 : 08:25:05
