You can't let a little thing like not knowing a database's structure keep you from your work. Without identifying tables and columns, you can still find specific values and columns.
2009-07-29
2,638 reads
2008-12-02
9,088 reads
i have recently had the need to search the every database on the server for a particular string.
i came up with this... it has lots of room for improvement but it works
2009-08-03 (first published: 2008-11-11)
980 reads
This utility will find strings in procedures, functions, views, and even check constraints.
2008-10-31
418 reads
2008-12-02 (first published: 2008-10-30)
1,399 reads
2015-04-24 (first published: 2008-07-24)
2,682 reads
Search for String Occurence with this script in your stored procedures.
2011-10-20 (first published: 2008-06-08)
5,317 reads
Discover how to use metadata for pooling information already resident in an application to create a flexible search interface that reduces complexity and increases users' productivity.
2008-03-13
2,613 reads
2012-01-09 (first published: 2007-11-13)
4,869 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers