how to open sql files
I have 2 files, please can anyone advise me on how i can open and access these files.
Name Type Counties Sql Server primary data file Countries_l开发者_StackOverflow社区og Sql server database transaction log file
Thanks
If you have SQL Server Management Studio you should be able to attach them with the attach command. http://msdn.microsoft.com/en-us/library/ms190209.aspx
If you don't you can download express versions from Microsoft. http://www.microsoft.com/express/Database/InstallOptions.aspx
Assuming you want to execute the statements against a SQL server DB, there's documentation for using osql.exe here: http://msdn.microsoft.com/en-us/library/aa213087%28v=sql.80%29.aspx
You can also open the files in notepad (as one of the comments suggested) and copy and paste from this into your favorite DB Query tool (Query Analyzer for SQL2000, SQL Server Management Studio or Visual Studio for SQL Server 2005 and above, or any of the myriad of other tools available)
精彩评论