When Generating scripts , do we need to run all the code?

Nigel Fernandes

10y716

When Generating scripts using SQL Server Management it also generates lots of other lines .. Is it necessary to execute all these?

Aren't these default settings ?

Example:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
Accepted answer
You are right, however, it is important to understand why it is there in first place.
SQL Server Management Studio doesn't know the destination server on which you are going to execute these scripts. And it is possible that the defaults on target server might be different than the source server.
So, because you should not start getting unexpected results due to different defaults on target server, it scripts these defaults too.
Needless to mention, this is pretty meaningless when both source and target servers are same. It's just that SQL Server Management Studio cannot make that assumption.
Hope it clarifies.
Nigel Fernandes10y ago
Thanks for the clarification.
Nitin Sontakke10y ago
Some of these scripting options can be used to turn it off!