Skip to main content

New answers tagged

0 votes

Where is SQLQuery1.sql saved?

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....
Paul White's user avatar
3 votes
Accepted

How to rename a "broken" view

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', '...
coderift's user avatar

Top 50 recent answers are included