Kind of where I was going with this but it's important, I think, to include the date columns in that so that you endup with a nice, whole datetime as...

Nope... that works too... I just thought I'd show another way.

I'm thinking that someone has done an update in a transaction with no commit from Query Analyzer... locks up the world sometimes.  Use sp_lock and sp_who2 to find out who's...

Concur with THAT!!

--===== Return user created tables only.  Ignores dtProperties, as well

 SELECT Name

   FROM dbo.SysObjects

  WHERE OBJECTPROPERTY(OBJECT_ID(Name),'IsMSShipped')=0

    AND XType = 'U'

'nuff said...

Oh no, no, no.... this is a lot easier than that... but I need you to post the CREATE statement for the table...

Heh-heh... My first inclination was to say "don't use text columns"   I won't even allow them into code at work because of...

Thanks Nick... I'm still curious though... why do you need to change the datatype of a column in a view?

I was leaning towards the previously suggested idea of some sort of permanent table for this and then I started thinking "spid" and then David stole my thunder

Yeah.. that's what I was kinda getting at... if it's all SELECTs, what's the problem

Also, what I've found is that a lot of...

Yep... I knew that, Mark I just didn't think that Shine recognized that because he said your code change didn't work and...

Yep... First, I changed the function to capture the data type... again, you'll need to change the name of the function...

 CREATE FUNCTION dbo.fnColumnsUpdated

        (@TableName SYSNAME, @BinaryColNums VARBINARY(128))

        RETURNS...

THAT would certainly be a limit, huh?   Yeah, I know they reached the end but then they said they'd limit it to 300...

Mr B... PRINT is exactly what you are looking for... if you don't want the rowcounts to show up in "standard" format, you can do a SET NOCOUNT ON and...

Books Online... comes free qith SQL Server... lookup "Database Design" (I think)...