Mark,

Thanks for posting the table schema...

Sorry to plague you with questions but trying to do this in a very simple fashion... I see that the TimeGenerated column is a DateTime...

I'm just about out of tricks on the Text columns, Charlotte... I'm still playing with it but haven't been able to come up with anything, yet.

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...