Hi Siva, Thanks for the reply.I am searching for any SMO methods available to do the same.Do you have any code uses SMO to call sql script by passing parameters?
sqlcmd requires ' and " quotes for different arguements. Thanks, Uma. On Fri, Jun 13, 2008 at 7:51 AM, Siva CH <[EMAIL PROTECTED]> wrote: > hi Uma, > Hope the following link might be of help to you. > > > http://gps678.com/1/8f68cab863dbbe9e.html > > Thanks, > Siva > > On Fri, Jun 13, 2008 at 5:31 PM, Uma Devi <[EMAIL PROTECTED]> wrote: > >> Sql file I mentioned here is just contains the set of sql queries with >> soem Exec statements in it. >> It is not a stored procedure.But it uses some variables that needs to be >> passed through command line. >> Eg : sqlcmd -S server -E -i someinput.sql -v dname='DBName' >> dbpath="C:\somedir" -o output.log >> >> i want to execute this programmatically >> >> >> >> On Thu, Jun 12, 2008 at 9:49 AM, Uma Devi <[EMAIL PROTECTED]> wrote: >> >>> Hi, >>> I need to execute sql file through c# program.Some sql file takes some >>> parameters that I need to pass the variables through C# program.Is there any >>> way to do it.I found out that sqlcmd can be used by passing all parameters >>> to sql file using Process class.But I am trying to find whether we can do >>> this programmatically in C#. >>> >>> Please help. >>> Thanks, >>> Uma. >>> >> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups ".NetIndia" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/TechdotNetIndia?hl=en http://www.satheeshbabu.com http://www.satheeshbabu.blogspot.com/ -~----------~----~----~----~------~----~------~--~---
