Hi,
http://support.microsoft.com/default...b;en-us;201716
can you look in the resolution section of this article and tell me how the hell you run this file?
If I double click on it, it opens up in Visual Studio.NET
Thanks,
Printable View
Hi,
http://support.microsoft.com/default...b;en-us;201716
can you look in the resolution section of this article and tell me how the hell you run this file?
If I double click on it, it opens up in Visual Studio.NET
Thanks,
Right click on the file and select 'Open With...' then select WordPad.
Or you can open SQL Query Analyzer and view the file in there.
doesn't it have to be run from sql server? just taken a stab at it not sure.
Run the script in SQL Server Query Analyser
Yes, the .sql extension is usually opened and run with Query Analyzer,
but if you don't have it and only want to view it, use WordPad.
Hey what happened to the time change on our postings?
Joacim,
I don't have SQL server installed, only MSDE. I'm not completely sure, but does it come with the query analyzer?
Thanks,
I don't know if Query Analyser comes with MSDE. But if it doesn't you could write a simple VB app (or even a simple VBScript file) that runs it for you. Simply reference and create an ADO connection. Connect to your DB using a correct connection string. Read and store the whole SQL file into a string variable and execute it using the connection object, or by creating a ADO command object.
Oh, yeah, thanks.