Importing a large SQL script into SQL Server?

If you're only trying to copy it into the query analyzer to run it, maybe you could just create a batch file using OSQL to run it from the command prompt.

Here's the MSDN for OSQL: http://msdn.microsoft.com/en-us/library/aa213090.aspx


You can always take your database offline and detach it. Then you can just copy the physical files over to the other server and attach it. Easy way.