Hi Bevan,

Thanks for that. both options work, I will use option 2.

Thanks for that.

That works.

Cheers.

Well said Jeff!

I will remember this saying!

Jeff,

Yes it explains it and well done. I did realise in the end that you were tricking PARSENAME to do the job.

Your solution was a solution thinking outside the normal...

Jeff,

This is a great bit of T-SQL magic!

I understand that the REPLACE Function is replacing the ' ' with a '.'

However how on earth does the PARSENAME Function retrieve the...

1) What Service Pack have you got on your SQL Server?

2) What version of the Oracle Client did you install on the SQL Server?

3) What version of is the Oracle...

Jeff,

There will only be 2 spaces and no periods.

Niraj,

I mentioned this in the original post. It pays to actually understand what one has expressed before you offer suggestions!

Yes! Subscriptions via Report Manger. And yes....I know about @ExecutionTime, but...

I'm talking about putting the date on the subject line in the email for a subscription.

I know I can put the date using the global variable @ExecutionTime, but I'm talking...

All you have to do is tell the publication NOT to create the schema at the Subscriber.

Go to the properties of the Publication and set the option not to create...

noeld,

Good stuff! After I added the article to the publication, i then ran the snapshot and it replicated only that article.

Thanks for your help, i have now understood the process.

Yes that it's exactly how I thougt it would work but unfortunately it performs an entire snapshot of the entire publication.

This is what I did.

1. Create new Stored Procedure

2. Add...

Firstly, who cares whether it works on Oracle & DB2!

Secondly, how have you ascertained that process 2 is blocked by process 1

Thirdly, How did you disable page locks and why...

Tobie,

This works well. I will use it. It suits our requirements.

Thanks.

We refrain form placing such code within the Application. I need a solution that will be handled by the Database Engine.