SQL Server Management studio 2008

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

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

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

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!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources