Tag Info

SQL Server Management Studio 17 saves my files here: C:\Users\myuser\Documents\Visual Studio 2015\Backup Files\Solution1 18/02/2026 11:10 AM 2,892 Original-Feb-21-2026-1031PM.checking-data-20260218....

SSMS basically does an sp_rename under the hood. That works even on broken views because it just updates the name in sys.objects without validating the body. EXEC sp_rename 'dbo.vw_t_dummy', '...