Click here to Skip to main content
11,709,375 members (35,489 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
Hi,
i have generated a database script in sql server 2008 r2 but it is more 512 mb in size and when i am trying to run this script on other system it gives error the size is more than 512 mb and it is not Executing. what to do to run this script.
Please help.Even it can not be open in notepad or word so i am unable to run it in part.
Thanks.
Posted 28-Sep-12 23:42pm
Edited 28-Sep-12 23:48pm
v3

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Try to Execute scripts in PARTS.
  Permalink  
Comments
ruby kaur at 29-Sep-12 5:47am
   
it will not open in note pad or word
damodara naidu betha at 11-Oct-12 2:53am
   
what is the extension of the script file? If it is .sql, then it can be opened if you rt click on it and select open with Notepad. If you double click on it it will launch SSMS there you can edit the .sql file.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 590
1 OriginalGriff 250
2 Maciej Los 225
3 Peter Leow 219
4 Mika Wendelius 160
0 OriginalGriff 9,428
1 Sergey Alexandrovich Kryukov 9,027
2 CPallini 5,189
3 Maciej Los 4,991
4 Mika Wendelius 3,856


Advertise | Privacy | Mobile
Web03 | 2.8.150819.1 | Last Updated 29 Sep 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100