ssms

SSMS vs SSDT

SSMS: SQL Server Management Studio.
- Object Explorer.
- Query Window (F5).

SSDT: SQL Server Data Tools.
- Object Explorer.
- Query Window (Ctrl + Shift + E).
- Source control, database projects, integrated debugger.

How to find and replace text in all stored procedures and functions

Use SQL Search tool from RedGate, a free tool which allows you to search a specific text in procedures, functions, triggers, views, constraints, etc. The steps would be the following:

1/ Get the generated script by SQL Search
2/ Copy/paste it in SSMS and replace your string (via CTRL-H) 
3/ Validate the new script (i.e execute it between BEGIN TRAN / ROLLBACK TRAN statements)
4/ If everything is ok then you can run it in SSMS
 
Subscribe to RSS - ssms