Cannot Attach Databases or Create new one - SQL Server 2008 [duplicate]

Question

Possible Duplicate:
SQL Server 2008 Express failed to attach mdf file

I use SQL Server 2008 r2, I am new at SQL Server , so I have some example files I want to attach it.

for some reason it showing the following messegebox :

Cannot show requested dialog. Additional information : parameter name : nColIndex Actual value was -1. (Microsoft.Sqlserver.GridControl)

Thanks!

Have a look here stackoverflow.com/questions/1424811/…

StuartLC
– StuartLC

2011-12-11 15:31:19 +00:00
Commented Dec 11, 2011 at 15:31 — StuartLC
– StuartLC, Commented Dec 11, 2011 at 15:31

user596075 · Accepted Answer · 2011-12-11 15:33:03Z

8

That's a known bug in SSMS Express. Use T-SQL instead, and you should be successful:

EXEC sp_attach_db 
    @dbname = N'yourDbName',
    @filename1 = N'C:\yourMDFlocation\DB_File.mdf', 
    @filename2 = N'C:\yourLDFlocation\DB_Log.LDF'

answered Dec 11, 2011 at 15:33

user596075

Sign up to request clarification or add additional context in comments.

3 Comments

thormayer Over a year ago

sorry for the dumb question , but , what is T-SQL?

John Allers Over a year ago

@user1054375 T-SQL is the proprietary extension to SQL used by SQL Server. stackoverflow.com/questions/1043265/…

user596075 Over a year ago

@user1054375, John Allers hit the nail on the head. T-SQL (Transact-SQL) is SQL Server's SQL.

Collectives™ on Stack Overflow

Cannot Attach Databases or Create new one - SQL Server 2008 [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related