开发者

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)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜