>Hi everybody,
>
>How can I check all tables for some data in them?
>
>Thanks in advance.


Can you describe a little better what you want?

This query will return an approx row count for each table

SELECT 
	CONVERT(VARCHAR(30), OBJECT_NAME(id)) [Table Name], 
    rows 
FROM sysindexes WITH (NOLOCK)
WHERE object_name(id) NOT LIKE 'sys%' 
	AND indid = 1 
ORDER BY 2 DESC

or, are you looking for specific data?