Allow user to disable dependant object refreshing
When getting latest SQL Source control always tries to refresh dependent objects. We have a scenario where we know we have broken objects (large database cleanup) and get latest fails because it tries to refresh those objects.
Add an option where users can skip that step. It currently generates code like below:
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Refreshing [dbo].[vSomeView]'
GO
EXEC sprefreshview N'[dbo].[v_SomeView]'
GO
5
votes
Tom
shared this idea