crishna1
asked on
searching for a string value
Dear Experts,
ia m looking for sql that will get me the string data in tables, using Sql Server 2000/2005.
basically i need find out the tables in which a string data is stored.
regards
ia m looking for sql that will get me the string data in tables, using Sql Server 2000/2005.
basically i need find out the tables in which a string data is stored.
regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
the above one will create a stored procedure , in order to do a search run this
exec SearchAllTables 'StringToBeSearched'
exec SearchAllTables 'StringToBeSearched'
ASKER
Can you briefly tell me what thsi doing and i guess, run this logeed in as SA on the desired database correct? what does it do?