hmmm

fixed it by doing an isnull(convert ... in the select

http://news.bbc.co.uk/1/hi/world/americas/3788229.stm

EOD for me

please, stop it now.

where were you when the poll tax riots kicked off ?

what was thatcher sacked by her own party ?

the ECONOMIC factors that caused the USSR to splinter...

I think you're missing the point Clint.

We come here for SQL Server help and articles - even though the original post didn't make a political point whayt is dismaying is...

the general convention here is that you should post details of table structures and any attempts you have made, or a specific question related to either.

it looks a bit like...

I think this is a very good point - whilst it's a nice thing to commemorate someone you admired and respected, the international visitors to the site are not going...

I must admin (being a Brit) I saw him as being on of the more dangerous Presidents you've had. I kind of equated him with Thatcher and as I grew up in the...

it turned out there were \r\n chars in the database ...

i'm using a cursor because (i had nothing to do with the audit data!) the front end returns say 8 rows of audit info but only 2 changes all linked...

i can't post the tables as my boss won't allow it.

at the minute i'm comparing 10 fields max in 4 didfferent cursors using temp vars and then comparing to the...

this should do it for you

exec dbo.sp_MSforeachdb @command1="select * from ?.INFORMATION_SCHEMA.ROUTINES"

information_schema.routines.routine_definition is a useful col as it contains the text of the SP

HTH

my guess would be to set a resonable query timeout at both ends. you can do this in EM by right clicking on your server and going to Connections and...

nothing to do with the post ...

but  'i'm a little french user' is the funniest thing i've heard in ages

you could kill the IT Network team ...

is this a permissions thing ? do you need admin rights to be granted again ?

this was given to me by a friend at work:

select @GlobalError = coalesce(nullif(@GlobalError, 0), @@error)

if @GlobalError <>...