Tag - SQL

1
Find Text In a Stored Procedure On SQL Server
2
How to Check SQL Database Connection without Server Management Studio on Windows

Find Text In a Stored Procedure On SQL Server

Time and time again I find the need to search all stored procedures for a table name or text in SQL server. Below is snippets of code that will do this task for you: SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id) FROM sys.procedures WHERE OBJECT_DEFINITION(object_id) LIKE ‘%TEXT TO SEARCH FOR%’ SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN[…]

Read More

How to Check SQL Database Connection without Server Management Studio on Windows

Stuck on a PC without SQL Management Studio? There is a utility built into windows that can be used to test SQL connections. Open up an explorer window: – Right click create a file name testConnection.udl – Accept that the changes and double click on the file – This will open up a “Data Link[…]

Read More