Thanks Sergiy and Lynn for these further informations.

I did not know about it and did not notice any performance problem with casting the dates.

However, as this is a trgigger, I'll...

Thanks for your answer shettybhas!

As Lowell stated, the problem was with getdate() returning a timestamp (date + hour) and the comparison was only on the date part; so it could...

Stupid me!!!!!!!

You are right Lowell.

Here's the correction if it helps someone ...

select @dt = convert(char(10), getdate(), 111)

Sometimes you're stuck with a problem for hours and you'd better have a...

Sorry, I missed the 3 first line

set nocount on

declare @dt datetime

select @dt = getdate()

BenWard (10/23/2012)

---

I often find articles written by people who speak English as a second language are done to a better standard of English that those who speak the language natively.

...

John Mitchell-245523 (10/19/2012)

---

rot-717018 (10/19/2012)

---

As I wrote earlier, I'm not english nor am I american ... I'm luxembourgish/french.

What would be the correct formulation for...

As I wrote earlier, I'm not english nor am I american ... I'm luxembourgish/french.

What would be the correct formulation for the above phrase?

Great article and thanks for sharing your experience!

I'd add one more point to the 4 you mentioned

Read your article!

This is from my own experience as I wrote many articles I...

[double post deleted]

Your first assumption is correct Gsquared. It is not a local SQL server.

Your explanations about multi-hops are very clear! No need to dig into kerberos, I fully understand what you...

Thanks for your hints Sushant

I already tried this out ... it didn't help 🙁

SKYBVI (9/30/2011)

---

btw why can't you...

To be honest, that's Chinese to me 😉

Another department handles all the networks and their setup (although I am Domain Admin)

Can you refine your question, so I can try to...

Thanks for your answer Gsquared.

1. Yes, the user under which the service runs has access to the UNC path

2. No, the file isn't opened in another application, nor is it...

Nobody knows how to help me?

Please tell me if I am on the wrong forum ... Thanks

Thanks for your answer opc.three!

it's only enhancement as the routine won't run often and crash even less.

Although too bad it is not possible to do it with T-SQL ...