Ditto. Points please for D. There was no equality operator between USER and 'BOB'.

This depends on the

large value types out of row

conifiguration setting. By default, they are in LOB pages. If the setting above is 0, they are in the record page up...

Yalena,

Obviously "the above" doesn't have dynamic scope as that would make the single choice questoin invalid - and we all know that no questions at SQL Server Central could ever be...

Grasshopper, you must be young.

Choice D implicitly defined the scope of "the above" variable the first time it was instantiated in choice D as choices A, B, and C....

It should be a "limited service" account. Microsoft in the reference that you provide for the question recommends "Always run SQL Server services with the lowest possible privileges." While the MS article says...

We all know that Central messed this one up.

Now as I was determining that Central messed this one up, I discovered an interesting anomaly.

What should be returned for

SELECT SIN(PI())

Now...

MS is not going to start using SP-double underscores ever. They've stuck with the SP-single underscore for all their versions. Furthermore, the SP-single underscore is thoroughly documented in BOL. They...

Start your utility stored procedures with an SP__, (SP-double underscored). This has three effects:

1. Your utility stored procedures float to the top of the list of stored procedures

2. I've never...

One would think that after 5-6 years, SQL 2000 would be a mature product with very little issues. Yet just last month I discovered a bug that will bring a...

When you are populating the record set, take out the GO between the next-to-the-last and the last insert statements. Having this penultimate GO in the set of queries will remove...

If you are interested in a replacement for SQL Mail, see my sample chapter at

http://www.wrox.com/books/1861008252.htm

It has a section on replacing exchange-based SQL mail with an SMTP-based solution. The...

For the wrapper, have the same input parameters as XP_SENDMAIL with the same data types. Have the parameters automatically default to the values that XP_SENDMAIL defaults for. That way when...

Another way is to junk XP_SENDMAIL altogether and use Gert Draper's xp_smtp_sendmail instead. It's much more reliable than a link to an Exchange server and works particularly well if the...

We always make our Outlook profile the servername and this helps this script to work. There is an undocumented stored procedure called xp_test_mapi_profile. You can see it being used in...

Do you have triggers on the publisher and the subscriber that might be putting duplicate rows in a table? You would need to make the trigger on the subscriber NOT...