There is a known bug in SQL Management Studio 2005 where when you try to generate scripts and you set 'Include Descriptive Headers' to false, then 'Append to File' will always be true.
Sadly they fixed this in SMS 2008, but didn't include the fix in SP3 for SMS2005.
The only work around I've found is to download SQLServer 2008 and use SQL Management Studio 2008. The downside to this is that the scripts 2008 generates differ from what 2005 generates.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=387334
No comments:
Post a Comment