This script extends the "Find strings in text of stored procedures" Script by LiviuB and and now finds thestring and removes it. You may modify script to just comment out the text.This script removes the text (in this case 'set dateformat dmy') from all non-system stored procedures in a database.Modify the variable @searchstring to contain […]
2004-11-26 (first published: 2004-10-13)
277 reads
Look, we all know data is king these days. But having mountains of data...
This topic keeps coming up with my customers so the purpose of this blog...
By Steve Jones
I realized that I hadn’t done much blogging on Window functions in T-SQL, and...
Hi, how to send emails on Azure Hyperscale server and which sp we...
I was trying to access SSRS report in host server browser , throwing an...
Sorry, more bakery stuff. Say I buy ingredients over time and I want to...
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers