Importing a SQL7 Database

#1

I have a SQL MDF and LDF file I need to import into an existing instance of
SQL7 server along with all stored procedures, etc. What is the best way to
do that through DTF?

#2

Have a look at

Exec sp_attach_db

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"jlc" <ultimedia_62258 (AT) yahoo (DOT) com> wrote

Quote:

I have a SQL MDF and LDF file I need to import into an existing instance
of
SQL7 server along with all stored procedures, etc. What is the best way to
do that through DTF?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Importing a SQL7 Database

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Importing a SQL7 Database - 04-27-2004 , 02:32 PM

Re: Importing a SQL7 Database - 04-27-2004 , 02:59 PM