They also become very useful as they can work recusively.

http://msdn.microsoft.com/en-us/library/ms186243.aspx

Ali Tailor (10/19/2011)

you can down load Express version free of coast as Ninja's_RGR'us said

and aditioonaly you can down load SSMS and If you don implementing any automation job AGENT is...

Steve,

Thanks for the reply. Couple of questions (related to your numbers).

1) I havent changed the config between reboots, so why would it now start working?

2) I have restarted my...

Ok - now this is wierd.

I havent touched the report - nor the config for the RS.

Restarted the server and its back rendering again.

Any ideas why? Memory leak?

Dan

I got that wrong due to the question being very vague.

However i do note that it must be hard to do this on a daily basis and get them perfect...

I am no expert (never used SQL audit) but you could do this with profiler.

Dan

Thanks all - thats perfect.

I am giving a stored proc to run to 3-4 people (who wont need to run it often). I didnt just want them to have...

Turns out you were half way there. I needed

LEN(EXPIRY_DATE) == 0 ? (DT_STR,50,1252)NULL(DT_STR,50,1252) : (DT_STR,50,1252)EXPIRY_DATE

Thanks alot for your help.

Dan