Monday, 19 October 2015

Scripting in Management Studio–delete sproc check if exists

SSMS 2014 seems to have lost the check fore exists before drop on scripting a stored proc.

You can turn this back on.

Yes to fix Tools -> Options -> SQL Server Object Explorer -> Scripting -> Check for object existence -> True

Personally, our code must be SQL 2005 compatible so I change that option as well as well as script triggers and indexes and disable scripting of USE DATABASE.

image

No comments:

Post a Comment