Seeing there's nothing on TV, I might as well add my last 2 cents worth.

Now this is just hypothesis, so feel free to trash it... maybe with the...

I had a similar scenario last week. Task Manager seems to get it wrong for individual processes when you get over a certain amount of memory.

I used the undocumented/unsupported/unrecommended...

Lorna,

You need to supply a maximum VARCHAR length in your CAST (same with CONVERT) function, or the max will be set at 30.

Compare:

select cast(replicate('1234567890', 20) AS VARCHAR)

with

select cast(replicate('1234567890', 20) AS...

Tim,

Without an ORDER BY in your SELECT statement, SQL does not guarantee the order in which rows are returned, regardless of any clustered index.

I know that 99% of the time,...

Hmmm, I wouldn't know what CONVERT does, but I'd guess it's more efficient than anything we could come up with using TSQL.

I'd stick with the CONVERT function. It's easily...

Yes...

SELECT ...CONVERT(VARCHAR(8),MsgDateReceived,108)AS A FROM mails_header...

Cheers,

- Mark

That's about as much sympathy as I expected.

Cheers,

- Mark

My mistake. I thought you were talking about people using their Windows credentials.

You might be a candidate for using an Application Role. See "Establishing Application Security and Application...

Although your string manipulation may be more complex than it needs to be, it looks ok to me.

Are you sure you're not getting the conversion error on the INSERT. ...

Remove the "Windows User/Group" logins from SQL (Security/Logins node in EM). Careful you don't remove your own access.

Cheers,

- Mark

Never tried that scenario. Although i have tried 2 servers each acting as standby for each other, so sort of 2 primaries and 2 standbys. No problems encountered...

deny all on tablename to whoever

grant select on tablename to whoever

PS. Peek in BOL

Cheers,

- Mark

The thing I can't work out, is why did Log Shipping try to re-apply #555 after it had successfully applied it 5 minutes earlier?

Does any sort of time sync occur...

I found the same problem. Upon trying out the scenario I found that Mary couldn't BULK INSERT into dbo.orders, even without the DENY in place.

I figured it must be...

I usually try something like this "kill & set" in an attempt to get the single_user option in before the other user/app does:

 

use master

declare...