Sorry but I'm not familiar with any of that.  at the end of the day I want to have a process that scans all tables in all databases and identified...

so I ran that and it worked but I'm not sure how to interpret the results.  First, is there a way for me to simply spit out the metadata such...

you would think but and maybe it will be but for now b/c this hasn't been implemented yet (stupidly) it is on prod tables.  there prob aren't many if any...

Hi..thanks so much.  just one question, what does the x.c in the select statement mean to infer?

well the PK alone doesn't indicate real world duplicates as in you can create an index column of sorts but that doesn't solve potential duplicates and even where there is...

the data above is sample, it's from SQL just pasted into excel.  using your code the error I get is

Msg 241, Level 16, State 1, Line 2

Conversion failed when converting...

sorry but I am stuck here.

when I try to declare the column 'filedate' in the variable it doesn't recognize it

DECLARE @myDate varchar(50)

SET @myDate = filedate

SELECT @myDate,CONVERT(datetime,@myDate)

select COUNT(filedate)

from TableUpdateStats

group by datepart(week,...

sorry but I have no code at this point

so attached are some rows from the query output.  You can see that while for the table referenced there are records for 'daily', there are far fewer than there should...

unfortunately I can't post the results of the query per company guidelines.  I think the calendar in a perfect world would be good, using it as a lookup table but...

so the thing is I have thousands of dates so I can't hard code them as a variable.  essentially what I need is for SQL to recognize the date, associate...