Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bbrown722
Starting Member
5 Posts |
 Posted - 2010-10-25 : 13:49:51
|
| Can someone help with this issue.find all the values of (X) in a database and not of tables names?BRENDA BROWN |
|
|
bbrown722
Starting Member
5 Posts |
Posted - 2010-10-25 : 14:05:26
|
| i do not know the table names.BRENDA BROWN |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-25 : 14:10:47
|
| Don't understand. Please explain more what you want.--Gail ShawSQL Server MVP |
|
|
|
bbrown722
Starting Member
5 Posts |
Posted - 2010-10-25 : 14:28:23
|
| select * from sys.tableswhere colname = host;I am trying to see every where PRDREMDB01 exist.BRENDA BROWN |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-25 : 14:48:33
|
| You want to query every column of every table for a particular value? A particular value in the data within the table?--Gail ShawSQL Server MVP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
finding and changing the name in db sqlserver 2008