Showing posts with label SSMS 2014. Show all posts
Showing posts with label SSMS 2014. Show all posts

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