SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / Generate sciprt for large table with command / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 22:15:20 GMT20RE: Generate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspxsounds like you are getting an error because you have a database greater than ten gig on a SQL express installation;my recommendation would be to spend $45 dollars and buy the [b][url=http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=sql+2008R2+developer+edition+download&rh=i%3Aaps%2Ck%3Asql+2008R2+developer+edition+download]developer edition on Amazon[/url][/b] so you can at least get started with fixing your data to fit into the ten gig limitation; you'll need to strip out or archive a lot of data to get it to comply with the 10 gig limitation again.otherwise plan on buying the standard edition for the production installation.Sat, 26 Jan 2013 20:26:03 GMTLowellRE: Generate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspxGet the SSMS Tools Pack. With it you can right click a table in SSMS Object Explorer and generate the series of INSERT statements required to take your data with you to another environment.[u][url=http://www.ssmstoolspack.com/Features#GIS]http://www.ssmstoolspack.com/Features#GIS[/url][/u]Sat, 26 Jan 2013 08:25:17 GMTopc.threeRE: Generate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspxIts for whole database , i want to run for specify table :)Mon, 21 Jan 2013 01:37:14 GMTgetsimrangujralRE: Generate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspx[quote][b]getsimrangujral (1/21/2013)[/b][hr]I want to generate script for a table through command[/quote] see this linl [url]http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/[/url]Mon, 21 Jan 2013 01:25:22 GMTBhuvneshRE: Generate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspxI want to generate script for a table through commandMon, 21 Jan 2013 01:07:47 GMTgetsimrangujralRE: Generate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspx[quote][b]getsimrangujral (1/21/2013)[/b][hr]generate script with large table ?? so i can run script in another database server [/quote] friend ,The problem is [i] "we cant see what you see"[/i], what you actually want in your query we dont know so better explain everything. see the link in my signature below.[center]Help us to help you [/center]Mon, 21 Jan 2013 01:05:03 GMTBhuvneshRE: Generate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspxSQLCMD -S LOCALHOST -d AdventureWorks -i C:\script.sql -E i want to run this for specify table . is that possible ??Mon, 21 Jan 2013 01:01:04 GMTgetsimrangujralRE: Generate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspxgenerate script with large table ?? so i can run script in another database server Mon, 21 Jan 2013 00:51:33 GMTgetsimrangujralRE: Generate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspxWhat do you mean by script a large table? Are you referring to data or structure? Mon, 21 Jan 2013 00:45:51 GMTbaabhuGenerate sciprt for large table with commandhttp://www.sqlservercentral.com/Forums/Topic1409377-391-1.aspxI want to generate sciprt large table with command , i couldnt able to do with SSMSMon, 21 Jan 2013 00:36:41 GMTgetsimrangujral