«

We are using a VS Deployment Project to distribute an ASP.NET app.
Presently we take script files to client and run them in Query Analyser of
SQL Server. But we want to automate running of SQL scripts along with the
application installer.

We tried using a project which reads script files and run them by passing it
to SQL Client's Command object, but this accepts only ONE entity's script at
a time.

So in order to create about 100 tables and 500 sp, we require writing 600
calls to the function which sends the script to command object.

If we create the script for all objects in a single file, the "GO" keyword
throws and error.

Please help me.


Nitin Singh
ASP.NET Developer

India

"Nitin Singh" <> wrote in message
news:...
> We are using a VS Deployment Project to distribute an ASP.NET app.
> Presently we take script files to client and run them in Query Analyser of
> SQL Server. But we want to automate running of SQL scripts along with the
> application installer.
>
> We tried using a project which reads script files and run them by passing
> it
> to SQL Client's Command object, but this accepts only ONE entity's script
> at
> a time.
>
> So in order to create about 100 tables and 500 sp, we require writing 600
> calls to the function which sends the script to command object.
>
> If we create the script for all objects in a single file, the "GO" keyword
> throws and error.
>
> Please help me.
>
>
> Nitin Singh
> ASP.NET Developer
>
> India
>
>
Check out this URL
http://www.codeguru.com/Csharp/.NET/...cle.php/c9601/

Thanks

the problem has been solved, by using the "regex " in the ExecuteSQL
function.

Nitin Singh

[prakashb]

Can you send me the code so that i can create for my project