Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL Server Management studio 2008

Author  Topic 

melissalove
Starting Member

3 Posts

Posted - 2012-08-17 : 13:52:17
why i can't enter database to attach?
how to make pass attach please help me ok.
i am deaf.
this look show picture.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-08-17 : 13:56:02
Use T-SQL instead. Here's an example from BOL:

CREATE DATABASE MyAdventureWorks
ON (FILENAME = 'C:\MySQLServer\AdventureWorks_Data.mdf'),
(FILENAME = 'C:\MySQLServer\AdventureWorks_Log.ldf')
FOR ATTACH;

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-08-17 : 15:41:34
Do you mean Attach (previously detached files) or create a new database?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-08-17 : 15:58:22
Just to be clear about my post, mine is to attach a database. Similar command can be used to create a new database. sp_attach_db is deprecated so use CREATE DATABASE FOR ATTACH instead.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

melissalove
Starting Member

3 Posts

Posted - 2012-11-29 : 09:14:23
Hello!
i ask sometime can help me i need SQL 2000 for download ok.
your SQL 2000 download link url copy to give me?
send kevin_dacasin49@yahoo.com
thank you very much!
Go to Top of Page
   

- Advertisement -