Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to attach DB to MSDE 2000, without using Sql Server components as Query Analizer or Corporate Administrator

Posted on 2004-09-24
4
Medium Priority
?
327 Views
Last Modified: 2012-08-13
How can a DB be attached to MSDE 2000, without using Sql Server components as Query Analizer or Corporate Administrator?
0
Comment
Question by:mak730
4 Comments
 
LVL 9

Expert Comment

by:miron
ID: 12147615
it would help if you describe in more detail what you would like to achieve

-- cheers
0
 
LVL 6

Assisted Solution

by:mcp111
mcp111 earned 300 total points
ID: 12147854
0
 
LVL 8

Accepted Solution

by:
plq earned 600 total points
ID: 12147931
Use freeware like DBAMGR2K, or write your own VB program to connect to it through ADO and then issue the sp_attachdb command. Personally though, I'd restore the DB or script it. I've always been scared that attachdb might go wrong due to server differences !
0
 
LVL 34

Assisted Solution

by:arbert
arbert earned 100 total points
ID: 12156593
Use the built in OSQL from a batch file/command prompt.

Brett
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question