Create Tables and stored Procedures in Microsoft SQL

[navmn mn]

Hi
I had created an database tables and written many stored procedures in Microsoft Sql. The server was changed, so I am accessing another server.

Now I have 2 files called "all.sql" and "tables.sql" . How do we create the previous tables and stored procedures using these 2 files.

Thanks in advance
Naveen

[Paul Sturrock]

Not really a JDBC question or a Java question; Query Analyzer has an "Open" option in its File menu - you could try that.