Great work Grant, thanks for the response. I suspected as such, but didn't have the nous to test it myself the way you have. Thanks again.

Wow, thanks BrickPack, that's really useful!

Unfortunately, I'm attempting to get some Business Intelligence folk (non-developers) to create and email reports to themselves using Report Builder. Looks like it's a problem...

Hi,

I'm having the same issue I'm afraid. All I see is a "Message Clipped" message in gmail, and the mhtml is only 13KB so I wouldn't expect it to...

Thanks Padraig, that worked for me too.

Elliott W (9/14/2009)

---

All of these things will work, but are you doing any source control? Don't you already have a copy of the way it was, and if not...

This any better?

 

select

case when month(@date) > 8 then convert(varchar,year(@date))

else convert(varchar,year(@date) - 1)

end

  +  '-08-01' 

That's the most pointless QOD so far.  This guy NECROSSOMUS really does produce some rubbish questions..

Sorted it now, the standard template was rubbish.

Thanks Brian, was looking for a cheeky way out, but it's not to be..

Is there any way or refreshing the sysdepends table, short of recompiling every stored procedure?

Does anyone use the dependencies to determine where a stored procedure is called from, or is...

Thanks folks, I like the look of COLUMNPROPERTY.  I'll give that a go..

Cheers

Got it working. Used a nvarchar, and an N before the string to identify it as unicode.

Cheers

It's along the lines of

if update(refno)

begin

select @before=convert(varchar(255),refno) from deleted

select @after=convert(varchar(255),refno) from inserted

exec WriteToCal @User,refno,@Before,@After,@Refno,@Surname, @Dob

end

This code is then repeated for several different fields. I obviously need to loop...

I was after a char(13) after all.

In the end I used

PATINDEX ('%' + char(13) + '%',@SPText)

and it produced the results I expected.

Thanks for all the help folks!

Thanks Chris, this has worked a treat!