SQL files normally contain SQL code to re-create database objects incluing tables, views, etc.
To run the .sql file, open it using Query Analyzer, then select the database you want the tables/objects to be built in (you should see a list of all DBs on your server in the drop down menu up at the top), then execute the query pressing the "Play" button or F5. Let me know if you need further details! Cheers mate, Denise. Denise E. White CTO Devbox Software www.devboxsoftware.com ----- Original Message ----- From: "SQL" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 03, 2003 6:18 AM Subject: SQL-List V1 #300 > SQL-List Fri, 3 Oct 2003 Volume 1 : Number 300 > > In this issue: > > Newbie Help Needed With Schema File > > > ---------------------------------------------------------------------- > > Date: Thu, 2 Oct 2003 19:23:16 -0500 > From: Chris Montgomery <[EMAIL PROTECTED]> > Subject: Newbie Help Needed With Schema File > Message-ID: <[EMAIL PROTECTED]> > > Howdy, > > I have a some .sql files that a colleague sent me. They include a .sql > schema file and several stored procedures. I cannot figure out what to > do with that schema file. I'm thinking there must be a way to import it > or some other way to get SQL Server to build the database tables that > will let me examine the structure. > > Can anyone walk a clueless newbie through the process of taking a .sql > schema file and getting it into a SQL Server database? > > Much Thanks. > > -- > Chris Montgomery > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| > Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. > http://affiliates.macromedia.com/t.asp?id=2439&p=go/dr_text_aff1 > > Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1677 > Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 > Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 > Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:use rid:>.<:listid:> > > > > ------------------------------ > > End of SQL-List V1 #300 > *********************** > >
