SQL Datatype detection 1

[normm]

Hi all,

Is there a really quick simple way to detect all of the variables within a database of a certain datatype.

I'm currently working with a large MS SQL server 2005 Express database and need to check for date and time fields within the whole database.

Any help Greatfully recieved.

Normm

 

[r937]

do a query against the INFORMATION_SCHEMA.COLUMNS view

r937.com | rudy.ca

 

[normm]

thanks r937 - exactly what I needed

Normm