Click here to Skip to main content
12,632,322 members (27,247 online)
Rate this:
 
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 29-Sep-12 0:42am
Updated 29-Sep-12 0:48am
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 29-Sep-12 5:47am
   
it will not open in note pad or word
damodara naidu betha 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 29 Sep 2012
Copyright © CodeProject, 1999-2016
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