The Simplest Question of all

[Dave Johnson]

Greetings,

i have a sql text file, and i dont knw how to execute it in VS.net 2005
sql express!

can anyone help!?

thanks,

Sharing makes All the Difference

 

[Cowboy \(Gregory A. Beamer\)]

There are a couple of ways.

SqlCmd - the command line utility.
I don't have the syntax for running from a script, but it is the SQL Express
command line tool (actually the SQL Server 2005 command line tool)

Express Manager - Have to download
Much easier, as it is a bit more graphical

Some intro info:
http://www.yukonxml.com/chapters/mann/Express/


--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

 

[Cor Ligthert [MVP]]

Dave,

I did not understand your question, but reading Gregory message I got the
idea, do you mean the executenonquery?

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx

I hope this helps,

Cor