I would replace the question "How many rows returned by executing all of the following?" in "How many rows returned by the last SELECT?" and add another answer: "None, because...

I agree with you!

Toreador (6/24/2011)

---

I wonder which of the following (if either) is more efficient:

select @a = 1 where @b-2 = 0

or

if @b-2 = 0 set

Toreador (6/24/2011)

---

I wonder which of the following (if either) is more efficient:

select @a = 1 where @b-2 = 0

or

if @b-2 = 0 set

This is true only if...

Yes, exactly!

michael.kaufmann (5/26/2011)

---

Carlo Romagnano (5/26/2011)

---

In sql2005, I tried with other logins than sa and I get always the following:

1900-01-01 02:00:00.000

Step 1: bad password attempt

Step 2: correct login

I run the query: SELECT...

-- to see all bad attempts

SELECT l.name, loginproperty(l.name, 'BadPasswordTime')

FROM sys.syslogins l

In sql2005, I tried with other logins than sa and I get always the following:

1900-01-01 02:00:00.000

Step 1: bad password attempt

Step 2: correct login

I run the query: SELECT loginproperty('carlo', 'badpasswordtime')

The result:...

I am curious: bol does not mention the...

I agree with you! 😀

Great question. 😛

In addition, the administrator should disable in AD and kill all disabled-user's connections.

Wonder question! 😀

It's a good habit always to specify precision and scale because of changing default in future releases.