Scripting Fail

Forum for users of SQL Packager database archive utility

Scripting Fail

Postby gsuttie » Mon Feb 14, 2011 9:50 pm

Guys

I am trying to script some data and either open in it in management studio or save it to a file and neither works, if the script is reasonably large it hangs and then says it cannot open management studio, I just want to get sone data from some tables and email it to myself or save it as a file but it just will not work. You cant go into the data script tab and copy - it just wont work for me (=

Gregor
gsuttie
 
Posts: 43
Joined: Wed Nov 30, 2005 9:09 pm
Location: Glasgow, Scotland

Postby james.billings » Wed Feb 16, 2011 10:27 am

If you've generated a script and it's pretty large, SQL Management Studio may well time-out trying to open it.
You should be able to run it from the commandline using SQLCMD though? http://msdn.microsoft.com/en-us/library/ms162773.aspx
james.billings
 
Posts: 1120
Joined: Wed Jun 16, 2010 11:10 am
Location: Red Gate


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests