We are currently on SQL Server 2000 and need to identify records with Czech Characters from the database tables. Can anyone guide me how this can be done in SQL Server 2005/SQL Server 2000 ?
So, the Czech characters are áčďéěíňóřšťúůýž, right?
So if you're looking for these characters, you should make sure you're using a collation that is accent sensitive. Then you can do something like:
WHERE col LIKE '%á%' COLLATE Latin1_General_CI_AS
...to see if you have this character used anywhere.
To get a list of columns, use sys.columns. Join to sys.objects and sys.schemas to find out what tables they're in. You're only interested in the columns which are one of the string types, so join to sys.types to get the ones you want.
Oh, and if you're in SQL 2000, then use sysobjects, etc. The principle still holds though.
No one has followed this question yet.