Thanks Drew

Yeah I know the table design is crap, unfortunately its part of a service desk application that was purchased by the organisation. So theres not really anything that can...

Thats interesting. I never thought of that.

So the trigger would just copy the "inserted" data?

thanks a lot

just realised i am being a bit of a dummy

i saved it a varbinary (max) datatype

works a treat

Thanks that seems to work (the varbinary casting)

I'd like to create a field and populate it with the varbinary value

what data type should the field be and should...

sorry i can't get this to work

That worked for me too.

Thanks Dom.

I would never have found that out on my own.

Cheers

Dom

I have the same problem, did you figure it out?

Cheers

Thanks Both

Thanks , Vista is a real pain isn't it?

I managed to use the config tool and it worked ok.

OK will do

Thanks guys

Thanks again

I don't have this. I think you have a more up to date version of IIS (I am running 5.1) I am also running XP Pro so cannot upgrade...

Sorry Callum, I think I'm being a bit slow on the uptake here.

If I go to IIS manager I have my computer (as a node) then "websites" and then...

Sorry just one last question - how do i know when is the app pool recycle time?

Thanks, that's great info.

So I can create a small app to call the page and then set that to run in the windows scheduler?