Dave Watts wrote: >> Thanks Dave. You said "open Query Analyzer and run the file". >> I don't see where in QA I can open a file... > > I don't have it in front of me, but I'm pretty sure there's an option to > open a text file. If you can't find it, you could open the file in Notepad, > then copy and paste into the T-SQL window. Of course, that would be pretty > slow, since it's a 900MB file you want to open. >
You could also use one of the command line utilities...osql in SQL 2000, sqlcmd in SQL 2005...something like... sqlcmd -S yourserver -i c:\900MBScriptfile.sql ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:255315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4