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 |
|
rbohaty
Yak Posting Veteran
71 Posts |
 Posted - 2008-12-06 : 10:27:17
|
| Does anyone have any scripts/tools that would help in identifying / locating credit card, banking, ssn information across all databases?Thanx |
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2008-12-06 : 22:12:35
|
| There is no one common naming standard which every one follows - so there is no script that can fit youAlternatively - you need to run a search accross your own METADATA to find possibly which table/column are holding personally identifiable data.TechnologyYogihttp://gvphubli.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-07 : 00:58:39
|
use INFORMATION_SCHEMA.COLUMNS to find out columns likeSELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%credit card%'.... |
|
|
|
|
|
|
Non Public user data