How about this?

SELECTCAST(LEFT(CounterDateTime, 23) AS SmalldateTime)

FROMCounterData

John

Awesome! Thanks for the in-depth analysis, Hugo, and for being more generous to me than I think I deserved. The first time I saw the queries, I assumed...

That suggests that the problem lies in what comes after the decimal point. What does this return?

SELECT LEN(CounterDateTime), COUNT(*)

FROM CounterData

GROUP BY LEN(CounterDateTime)

John

What does this return?

SELECTCounterDateTime

FROMCounterData

WHEREISDATE(CounterData) = 0

John

This is one of the problems with storing dates with the wrong data type. Not a criticism of you, since this probably isn't your design.

You only need one of...

There's very little difference. On SQL Server 2008 R2 SP2, there was an extra...

Could it be a rounding error?

John

First, you need a table with all those August dates in it. Do you already have one? If not, you can create a permanent one or use a...

I think the only way is to make the user the owner of the databases in question. From the documentation:

If the database being restored does not exist, the user...

Looks serious. Use your favourite search engine to investigate this error: SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. You may have...

Posting exactly the same thing again doesn't alter the fact that it's from SQLAGENT.OUT, not from the SQL Server errorlog. From the Access Denied error, I'd say you've got...

Yes, I think you've nailed it. Take a look at the very bottom line of...

That's telling you that SQL Server Agent stopped because SQL Server stopped unexpectedly. To find out why SQL Server stopped, try the SQL Server errorlog or the Windows event...

I didn't get that. What is your server collation set to?

John

So you don't want XXX to be able to change YYY's permissions? Start by removing XXX from sysadmin. What do you want XXX to be able to do?

John