This is SQL 2005 - not 2000. Where can I find query analyzer? >> I have a database dump (> 900MB> in a .sql file. It has all >> the sql to create a database and put data in. I want to use >> it to make a db in SQL 2005 but can't find a way to do this >> using import data / transact SQL etc. Does anyone know how to >> do this? > >If the file contains a CREATE DATABASE statement, open Query Analyzer and >run the file. If it doesn't, create an empty database, open Query Analyzer, >switch your database context to the new empty database, and run the file. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254956 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

