I need to find a table and column name from some given data. I know what data i want to edit, I just need to know where it is located and the database is too big to manually go through. It is Microsoft sql server 2000. Any help is appreciated.I don't understand your question.|||Is this what you're trying to say?
I want to search my entire database for one piece of information and return the table and column name where the data is?|||Yes that is what i am trying to say. I know how to write the replace code, I cant find where the data is located.|||problemss, the data you want is in the verpflugten table in the geschnitten column
:)|||blindman has posted code for this but I can't find the link...
Perhaps he will come along later and repost it.|||You might be thinking about this
http://weblogs.sqlteam.com/brettk/archive/2005/02/08/4144.aspx|||here's another way:
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm|||You might be thinking about this
http://weblogs.sqlteam.com/brettk/archive/2005/02/08/4144.aspxSame idea... different author :)
It was defo blindman because I PMed him some optimisations :) ...which he ignored :o|||Thank you guys so much, that was it. I really appreciate all your help. I am going to be bookmarking those links. Thank you again.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment