This script creates a stored procedure which helps to find text in all of your code objects in all your databases. It searches the code of SP's, UDF's, views, triggers, and it searches in all databases.Output is a result set with DbName, ObjectName and ObjectType.Advantages are- works reliable also with source codes longer than 4000 […]
2004-03-31
268 reads
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Hi all, I am running the following query in SQL, trying to export some...
Please suggest practice on SQL Server RLS On the database level, defined users with...
Ask SSC