January 14, 2011 at 8:50 pm
Hello
I get the above error while executing an .sql file that contains about 30mb of simple inserts. How can I get around this please ?
Regards
Mihai
January 15, 2011 at 5:49 am
Can you give a little more information?
What version of SQL Server are you using? What service pack level?
What do the queries look like? Are you using a linked server?
Are you using temp tables?
...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2011 at 6:02 am
I've tested on Sql Server 2008, one had SP2.
The queries are - simple - inserts with no temp tables, no nothing. It was generated for migrating data over.
January 15, 2011 at 6:19 am
Dinculescu Mihai (1/15/2011)
It was generated for migrating data over.
Migrating data from what to where?
In the same DB? In the same server? Or across different servers?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2011 at 6:22 am
I wrote a c# script which parses a few mysql tables, generates the according insert statements and write them to a file. Then this file is supposed to be ran in mssql management studio.
January 15, 2011 at 7:08 am
Looks like adding some GOs between the inserts solves this issue. Makes sense, I'm ashamed I didn't figure this out faster.
January 15, 2011 at 9:46 am
Dinculescu Mihai (1/15/2011)
Looks like adding some GOs between the inserts solves this issue. Makes sense, I'm ashamed I didn't figure this out faster.
I'm glad you found the solution! (rather easy when you look back at it :-))
Thanks for posting it here.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply