You're welcome Miguel. This won’t be the first (or last) time any of us find ourselves in this situation. The reason I knew about the delete level is from working...

You could also use the @delete_level parameter of sp_add_job.

0 = Never

1 = On success

2 = On failure

3 = Always

When using SSMS to create/modify the properties of a job this appears...

Be careful. The ROUTINE_DEFINITION returned by INFORMATION_SCHEMA.ROUTINES is nvarchar(4000). Using this view will miss references beyond that for procs/functions that are more than 4000 characters. The same goes for VIEW_DEFINITION....

Ditto. According to BOL the model database cannot be set...

Michael Kipp (6/25/2009)

---

Maybe it's just me, but I read the question differently, looking for the SQL Server data type to match the MS Access data type. Might be that my...

Noel McKinney (6/5/2009)

---

Respectfully disagree with the answer; I'd actually say varchar(1) is the worst choice. You've got the +2 byte overhead for allowing variable length when the question states the...

I wasn't sure which way to go either between "national character varying" & "national varying character", but then I saw this in BOL so I chose the former.

(nvarchar data type):...

I was thrown off too. The documentation is inconsistent.

At first I found the capacity limitations page that indicates 50 instances on a stand-alone server for all SQL Server editions except...

Yes I was using a sysadmin...

I tried this out on Windows 2003 to see how it reacts (Windows 2003 SP2; SQL Server 2005 Standard SP2 64-bit).

Using the SSMS GUI, the following commands are issued.

[font="Courier New"]--...

Ditto the above concerning sp_describe_cursor_columns. Can the question's author please give an example of how the number of rows returned by a cursor can be obtained by calling sp_describe_cursor_columns? If...

Wikipedia (http://en.wikipedia.org/wiki/Yottabyte) would have you believe that all four answers are correct, using base 2 or 10.

The quoted reference in the answer (http://en.linuxreviews.org/Yottabyte) would have you believe that only two...

yussuf.khan (2/11/2008)

---

just a wee thought on this article. Surely what you are talking us through here is the same as is accomplished by the Slowly changing dimension 'box' ....

I'm wondering the same thing as Gordon. As is often the case, it seems that there are multiple ways of accomplishing the goal.

Quote from SQL Server 2005 Books Online:

Connection...

In addition to the problems listed above, Answer 1 also returns "yes" for an empty string.

Why is Answer 3 incorrect?