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