i have changed the value of .mdf in the registry to the
"SQLServer.Engine.PrimaryDataFile", but still have problem. please help

özcan (zcan (AT) discussions (DOT) microsoft.com) writes:
Well, if you tell us what your problem is, we might be able to.

But there is no reason to fiddle with file extensions in the registry.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi,

I think you might have to tell us a bit more about what you have done and
what you want to achieve? Otherwise it might be difficult to give you any
help.


--
Regards
Steen Schlüter Persson (DK)


"özcan" <zcan (AT) discussions (DOT) microsoft.com> wrote

the files that ends with .mdf are not associated with the sql server 2008. i
tried to fix it from default programs and then from the registry,
HKEY_CURRENT_USER\Software\Classes\.mdf and
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\.mdf . But still have problem

mdf files look like an other program's file. i just want to fix this, make
them look sql server's file again.

özcan (zcan (AT) discussions (DOT) microsoft.com) writes:
I can't see that this has any practical importance. It's not that you
open a database by double-clicking it. SQL Server will open the database
files according to the path that is stored the system catalog, no matter
what the file extension is.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx