Can't connect databases or create a new one - SQL Server 2008

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

I am using SQL Server 2008 r2, I am new to SQL Server, so I have some sample files that I want to attach.

for some reason, it shows the following messegebox:

Unable to display the requested dialog. Additional information: parameter name: nColIndex Actual value: -1. (Microsoft.Sqlserver.GridControl)

Thanks!

+6
source share
1 answer

This is 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' 
+8
source

Source: https://habr.com/ru/post/903553/


All Articles