Thanks for your reply.

An alias is not what I need in this instance but you have answered my question regarding the column level synonym.

I did try to create...

OK good.

You are quite right about the 2 seperate filegroups. Although you could have 12 filegroups I dont see any benefit from doing this unless you wanted to make some...

Are you using SQL 2005?

For anyone else who needs to modify the script to use SQL 2005 dbmail just change (assuming db mail is correctly set up already)....

EXEC master..xp_sendmail @recipients = 'email@domain.com',

@subject = @MailSubject,

@message...

Thank you. Both ways work a treat. 😀

This article will probably be of more use to you http://msdn2.microsoft.com/en-us/library/ms151255.aspx

My setup does not involve replication via the web so am not 100% sure of the config, sorry. I...

You will need to be able to resolve the server name in order to connect via management studio, I used host entries to achieve this. Can you ping the destinatation...

I am using the ReportViewer. Thanks for your reply that answers my question.

Go it.....

'

+''''+''''+'

Thanks for your help!

I just get back;

Msg 170, Level 15, State 1, Line 29

Line 29: Incorrect syntax near '1211'.

1211 being the variable and line 29 being the start...

Thanks for your reply. In the end I managed to do it like this;

=IIF(Fields!Exam_Description.Value

LIKE "*Real*"

AND

Fields!Date_Received.Value <

The execution plan shows an 18% cost on the join, a 47% cost on the clustered index scan on one table and a 22% cost on another clutered index scan....

That's great thank you very much.

That looks to be working correctly!

Thank you for your help it is much appreciated.

I did try this a little earlier but still didn't have any luck.

Is it possible to use something like NOT LIKE "*Real*" in an expression?

Thanks