Right-click the key you're interested in and select Permissions. However, the SYSTEM account really ought to have permissions on everything in the registry--I'd be surprised if there was any part...

Had to read through the BACKUP item in Books Online to be sure what would happen here, because it certainly makes no sense to put a backup inside a transaction...

I had a suspicion that the obvious answer was going to be wrong, but I selected it anyway because I was curious to see what the actual answer was. One...

Is the SQL Server Agent on the secondary server running under an account that has access to the log shipping folder on the primary server?

Doesn't that depend on the SQL...

One problem you might have is that the total possible row length you've got there is well in excess of 32k--way higher than the little-bit-less-than-8k SQL server provides! If you...

I was expecting an answer of 3 or 5, but I wasn't sure which, so I created a temporary table to check--was somewhat surprised to see no rows at all...

Normal human being? Well, sort of, although there...

Steve Eckhart (8/27/2010)

---

Actually, we're doing the exact same thing here. This was the original query:

while @i <> 1

begin

declare @a table(a int)

set @rc = @i + 0.9

set...

Can I be the first person to be picky enough to point out that Batman isn't technically a superhero, since he possesses no superpowers? 🙂

You're only adding one...

This is actually a really hard question. I think it would have to be Reed Richards, of the Fantastic Four, simply because he solves most of his problems using his...

I actually guessed the outcome as soon as I saw the comparison--but then, I was a programmer for ten years, and I think "DO NOT DIRECTLY COMPARE TWO FLOATING-POINT VALUES"...

Is it...

Nope, just tested it on a SQL 2008 Express install and it came up with an arithmetic overflow as expected.