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,114 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)
985 reads
This utility will find strings in procedures, functions, views, and even check constraints.
2008-10-31
423 reads
2008-12-02 (first published: 2008-10-30)
1,415 reads
2015-04-24 (first published: 2008-07-24)
2,692 reads
Search for String Occurence with this script in your stored procedures.
2011-10-20 (first published: 2008-06-08)
5,369 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,894 reads
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Databases and Disasters
Comments posted to this topic are about the item Automating SQL Server Access Review
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers