Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Executing SQL script file

Author  Topic 

hemchand
Starting Member

2 Posts

Posted - 2003-05-10 : 14:43:28
Hi,
I want to execute an SQL script file from C#. I want to know if i can pass this file as a command line argument or something like that. Is there any utility with SQL server that will serve my purpose?

Thanx in advance
Bye
Hemchand

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-05-11 : 01:53:20
Few ways to do this.

1. OSQL
http://www.sqlteam.com/SearchResults.asp?SearchTerms=osql

2. SQL DMO
http://www.sqlteam.com/SearchResults.asp?SearchTerms=dmo

3. ADO.NET and stored proc
http://www.sqlteam.com/SearchResults.asp?SearchTerms=stored+procedure

Go to Top of Page
   

- Advertisement -