Cheers John!

Below is roughly the script I have... I dont replacing the CHAR(13) function with </br> is going to do the trick???

Any suggestions???

declare

test_cur cursor

Thanks for this James... I will take a look....

If you can split your parameter into seperate month and year parameters, try:

select * from vacation where datepart(mm,exitdate) = @month and datepart(yy,exitdate) = @year

--datename function does roughly the same thing.

Almost certain it is not being sent by html... tried adding the <br> but the proc didnt like it!!

I am using MS Outlook 2003, SP1.

Do you know what settings I should check? Outlook isnt my strong point.

Thanks Again

Gary.

Hi Noel.

Yes, I am using SQL 2005. I know that I could see the backlog by clicking on the subscription properties and checking manually. What I need is to be...

Just to close out on this topic, it seems that the login that we were using was being used by another server on the domain that we were unaware of....

Yes, I logged out of the domain.

I am thinking that if there were any other legacy connections with the login, would the new connection with the login inherit these priviliges...

I checked to ensure that the login is not a member of any other SQL group. The background to this issue is that we are trying to remove a lot...

The login is still a domain login but I deleted it from the Active Directory group.When I readded the group as a SQL Server Login, and tried to connect to...