Johan, you are right, as the app is designed to be used globally and is therefore attempting to store the date without including time zone offsets it should store the...

its a copy process causing the errors so definitely not internal to SQL. Unlikely to be the SAN either.

As it is intermittent and happens to a file being moved between...

thank you Johan.

Looks Like I have options to present to the developer. I do spoil them.

I should have known better and explicitly stated SQL2005 but your code looks quite compatible...

Lowell, Hi, thanks for replying

BST is British Summer Time, the clocks go forward one hour in the spring and back an hour in the autumn, so I would say that...

just been trying out CMS.

Is it me or are the instructions in MSDN on setting it up inaccurate? I don't get the drop down options as they specify them...

thankyou James. You just proved my point. 🙂

and it is very important if you receive service that has been 'above and beyond' that you provide feedback to that effect. Hopefully that will reinforce the behaviour and ensure...

I must look into this as we migrate to SQL2008.

Presently we...

Geoff A (9/22/2010)

---

SSIS running a package every x minutes will do this very well and we have used this in OLA 1 production environments for some time.

we use the following...

its one 3 node cluster with two instances sitting on it.

set up is the same you will have two SQL resource groups

yes it is, as long as the passive node is capable of supporting both instances at the same time (or the SLA states that a performance degradation is acceptable in...

does anyone see a use for dbcc timewarp here:

http://www.sqlservercentral.com/Forums/Topic991811-146-1.aspx

or maybe sp_configure 'go faster',1

which reminds, the article on what we would like to see in SQL, a go faster button is...

yes

have one...

Also, is it just you or everyone?

Whats in the error log after the login failures?

Is shared memory activated?

but can he act?