Boy, I'd have to agree with, um, everyone here, starting with Tomas.  To address a question some of you seem to have, if FMTONLY is on, then only metadata is...

I would have been interesting to throw a division operator into the mix, such as:

DECLARE @Total int
SET @Total = 1 + 2 + 3 / 4
PRINT @Total

I wonder how many...

Hi Mike,

You said:

... we can get either striped backup or 2 un-striped copies, depends which files we highlight. 

How do you use the GUI to get 2 un-striped copies?  Although...

Hans,

Backing up over two or more files (I assume you mean a striped backup here) is useful for speeding up large backups that otherwise might not be do-able inside a...

If you get the error that says you need to BACKUP WITH FORMAT it just means that these two files have not been used as a stripe set together before AND...

Leon said:

Besides... I am Dutch.

<...>

To me it is Vrijdag.

You can set your language to Dutch, as in:

Query:

set language N'Dutch'
select datename(dw, getdate())

Output:

Changed language...

Initially, I've got to say that I agree with alzdba and the others.  For a long time, I have seen people claim that you must qualify object names with explicit...

Actually, I meant what I said ... "(minit like '[A-Z]' or minit is null)" ... meaning that I'd rather have null middle initials than empty strings.  But it was just an...

If we're going to discuss preference (as opposed to correctness ... the stated correct answer is quite correct in this question), then I would prefer

CHECK (minit like...

Hmm ... usually I can figure out what the "correct" answer is supposed to be, even if the question is worded in a strange way.  But this question is worded...

True Confessions:

I chose the correct answer, just going from memory.  In practice, I don't think I've ever run up against the problem that the "correct answer" implies - specifically, having...

The most interesting thing about this thread - to me - is that all of us who have posted probably understand one or more of the common ways to do this,...

Following Tomas's lead, here's a page I found on Google that verifies that CA has an executable called dbasvr.exe:  http://support.cai.com/Download/patches/musthave/exant.html.  Maybe you need to talk to them if you...

Glad you got it working!  And thanks for the info that DBO_ONLY still works in SQL2K - I didn't know that.

Cheers,

Chris

> How does one turn it off?

According to the Data Source Wizard Help file, you can only turn it off for older versions of SQL Server.  It is controlled...