Or this:

CONVERT(VARCHAR(10),GETDATE(),101)

Can you not use Datepart?

Thanks for the reply.

Yes, I've checked that article out, and many others, but thanks anyway.

I have tested it and it seems to do what I expect but I think...

Thanks - yes that makes alot of sense.

Apologies I'm quite obviously being dumb, the problem is around not giving the db_datawriter role.

Jon

Thanks for the input.

Sorry the account currently has db_datareader and db_datawriter roles as it needs to update\insert them.

Perphaps thats where i'm wrong I should take off db_datawriter and then...

Hi,

Thanks for your response.

Yes I had checked books online and also googled quite a bit. Everything I found supported my view but the person I was discussing with seems...

Hi,

Under SQL 2000 this pretty much always pointed to 1 thing, that the Network Protcols were not enabled. However, under 2005 this error seems to be far more common. The...

Not sure I understand, please explain further.

Have you checked the security information of the Linked Server?

Thanks for your response. Thats what I thought, but thank you for clarifying that with me.

Regards

Jon

Hi All,

Yep I got it to work, with your help, I had the Server set to British English and the Login set to just English. I did'nt know it was...

SQLBill - Yes, I have tried checking with ISDATE, I do not beleive it is a problem with the data as such, more of a configuration issue. I have checked...

I've tried against several different date fields in several different tables and always get the same result.

The db is an exact copy, backup + restore.

I've reduced the data set...

Try this.

Declare @var1 char(2)

Set @var1 = 'xy'

EXEC('Select ' + @var1 + ' from table_ab')