November 4, 2011 at 8:55 am
Hi,
I have created a script that as 167 MB of size.
Inside the script the data is like:
Insert into tabela values ('teste','teste1',teste2)
Almost a million inserts.
Whemn try open the script with MS it says that it does not have sufficient memory.
This is a server....
Can someone help?
What to do when you want to run a script with this size?
November 4, 2011 at 9:42 am
try running the script using sqlcmd. -i parameter allows you to use the script.
November 4, 2011 at 9:44 am
Instructions here: http://msdn.microsoft.com/en-us/library/ms170572.aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply