HELP !!! - How can a run a sql script to install a

[aplaz]

I am new in the .NET developing world. My problem is that I am trying to install a DB that comes with the starter kit for Commerce, and I need to rum some sql scripts that come with it, and I do not know how to do it...how can I run these scripts?

I am using a Web Matrix and MS SQL Server over Windows XP Pro.

Thanks,

aplaz

[bruce]

If you do not have SQL Query analyser, you can also use the command line interface, osql.exe, which comes with MSDE.

Syntax:

osql -S [servername] -U [sqluser] -P [password] -i [File_containing_SQL_Script]

eg. osql -S mssql01.discountasp.net -U testuser -P password -i installscript.sql


[b]quote:Originally posted by aplaz

I am new in the .NET developing world. My problem is that I am trying to install a DB that comes with the starter kit for Commerce, and I need to rum some sql scripts that come with it, and I do not know how to do it...how can I run these scripts?

I am using a Web Matrix and MS SQL Server over Windows XP Pro.

Thanks,

aplaz
</blockquote id="quote"></font id="quote">

[tourneymanagerpro]

If you have the MS SQL Server client tools installed:
<ul> Open MS SQL Server Query Analyzer (from Start->Programs-MS SQL Server menu, or through Enterprise Manager) Connect to database you want to run the script on Click File->Open... and select the script you want to run Press F5 key or click the Arrow toolbar button to execute the script[/list]