Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SMO Scripting and SET commands
0 views
Skip to first unread message
Tom
Oct 8, 2008, 10:47:00 PM10/8/08
to
When I script tables the set statement all appear on one line with no break
between them.
SET ANSI_NULLS ONSET QUOTED_IDENTIFIER ONSET ANSI_PADDING ON
between them.
SET ANSI_NULLS ONSET QUOTED_IDENTIFIER ONSET ANSI_PADDING ON
Which option or set of options do I set to get these to appear on seperate
lines with a go between them. I am using SQL2008.
Thanks
Tom
mikedevenney
Nov 20, 2009, 9:13:22 AM11/20/09
to
It's been a year a no response, eh? I just found SMO yesterday and decided to whip something up to help me with scripting my deployments. I'm loving how easy it is to use so far but this has me stumped. If anyone stumbles across this please point us in the right direction, thanks!
To wrote:
SMO Scripting and SET commands
08-Oct-08
Thanks
Tom
Previous Posts In This Thread:
On Wednesday, October 08, 2008 10:47 PM
To wrote:
SMO Scripting and SET commands
Thanks
Tom
EggHeadCafe - Software Developer Portal of Choice
Handbook for Reluctant Database Administrators
http://www.eggheadcafe.com/tutorials/aspnet/8b4b1844-f3ae-41f1-8144-10631385f3a2/handbook-for-reluctant-da.aspx
Michael Coles
Nov 20, 2009, 12:20:15 PM11/20/09
to
Are you scripting to a file or a string collection? IIRC SMO will add the
GO batch terminator when you script out to a file, but you're responsible
for adding your own as necessary if you're scripting to a string collection.
GO batch terminator when you script out to a file, but you're responsible
for adding your own as necessary if you're scripting to a string collection.
<Mike Devenney> wrote in message
news:200911209131...@verizon.net...
0 new messages