dawryn (11/26/2009)

---

What is the use of a job if there is no service to...

I can't see anything about jobs there. The link seems to be not relevant to the question.

ZeroFusion (11/24/2009)

As for the length constraint - according to the MS SQL Data Types list, "Floating precision number data with the following valid values: -1.79E + 308 through -2.23E -...

Ol'SureHand (11/4/2009)

---

IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).

That is because the BACKUP command comes AFTER...

The correct answer is: A is '' (empty string), B is 'Chris'.

Try this code:

declare @name varchar(12)

select @name = 'Christopher'

select case when substring(@name,15,12) is null then 'NULL' else 'NOT NULL' end...

This behavior has been changed in MSSQL 2008 (see "model Database" in BOL 2008: http://msdn.microsoft.com/en-us/library/ms186388.aspx). Now the recovery model of 'model' database "depends on SQL Server edition".

Didn't find anything about...

Not quite correct. You don't need to...

I am disappointed with the question, too.

If I copied the script into SSMS, I would get the right answer. Instead, I took a piece of paper and wrote binary 'ones'...

What about CAST/CONVERT? These functions are scalar, built-in; XML data type can be...