Recognizing Database

[Punchinello]

I am running a version of SQL Server on a stand-alone XP workstation. Which version is running I do not know but it came with the Office XP Professional (I'm pretty sure). I can use the Upsize Wizard in MS Access and create databases that are accessible under SQL Server and this makes me happy.

But wait! Now a client has sent a database (.mdf, .ldf) that contains the data and stored procedures that I need to use and I cannot get SQL Server to recognize it. I have no tools, (but of course the server function runs fine), and am wondering how to add this database to my little server?

p.s. I have read faq962-4344 as to my version and I believe I have the Desktop Engine. I am developing a front-end in Delphi against the client's existing database.

 

[JayKusch]

in enterprise manager under the database tab, you need to right-click it and choose attach database, then point to where your mdf and ldf are.

Thanks

J. Kusch

 

[Punchinello]

Thanks for the reply, but I don't have Enterprise Manager. In fact, I have nothing but the SQL Server Service Manager.

 

[Punchinello]

My problem is solved! You see, I was searching the web for keywords like "recognize" (which, of course, in retrospect was silly), but JayKusch used the correct term "attach".

My next web search netted an article by Alexander Chigrik that explains the usage of built-in stored procedures that attach and detach databases from the server. Here's the link:

http://databasejournal.com/features/mssql/article.php/2224361

So I created a Delphi program, opened a server connection and ran the stored procedures referenced in this article with my own parameters.

and once again, I'm happy.