I have a remote SQL server (SQL Server 2000) which has a table that has nearly 60,000 records. I am able to script this table but cannot execute it locally, so as to replicate the table for local development.
I am using SQL server2008R2 Express. Thinking it was the Express version which was limiting me, I tried the same thing on a proper SQL server 2008, but still I get error when executing the script.
The script is 147MB but compresses down to 2mb when zipped.
On My Local SQL the error is “No able to execute the script” ‘system.OutOfMemeryExcepti
For years I could script this table with no issues.
I have attached a script to create the table only, so as to allow you to see the structure.
Thanks in advance.