Question Locked

Open an external sql database

0 helpful

2 replies

by cisyitec Feb 14, 2009 last reply Feb 14, 2009

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a SQL database file with the log file from a textbook. I would like to know how I can open this database within my MS SQL 2005 environment.

2 replies

Clarifications

this one (from Microsoft) works

use master
go
sp_attach_db 'mydb','E:\Sqldata\mydbdata.mdf','E:\Sqldata\mydblog.ldf'
go

This discussion is closed to new replies.