Scripting Fail

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

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: 44
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: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests