13.0.1500.400

It would depend on if the database backed up contains Enterprise features or not. If not the backup should restore with no problems. The question doesn't say that there are...

from sql help http://msdn.microsoft.com/en-us/library/ms186865.aspx

Under the full recovery model or bulk-logged recovery model, conventional backups also include sequential transaction log backups (or log backups), which are required. Each log...

First result depends on what has been run previously in the query window. If nothing has been run, then get a 1, second result is 1.

If a SET option e.g....

For that query to work it should be grouped by salescategory, salesperson, otherwise you will get this error when running the query

Columns salescategory, salesperson are invalid in the select list...

There is a db_sysltduser role in the msdb database, but not db_sysitduser role, looks like a uppercase 'I' was mistaken for a lower case 'l' in the role name!

Assuming that the evaluation edition has not expired.

The problem will also occur if you are sending attachments with the email and the attachment cannot be found by SQL Server.

Yes, if @var is more than 125 characters long, it will always return 'no' as the replicate value will exceed 8000 characters

Maybe the explanation should read:

The null value in SQL Server is replaced by 2 which is then implicitly cast as DateTime by the SQLServer, resulting in 3 Jan 1900

Answer correct, but explanation is a bit off, ISNULL replaces null values with the second parameter casted as the type of the first parameter, it doesnt add 2 to anything.

From...

It works, thhough I have never heard of it before this question.

You cannot specify a table identifer before the Id_A in the join expression otherwise the query fails, You...

Very similar but not the same

21 July question was

 'AWE allows SQL Server to address how much memory on SQL Server 2000 Enterprise Edition?'

This one is

'AWE allows SQL Server to...

There is no easy way to work out which ones you havnt answered. However, if you have time you could use the link to the question page, to see if you...

4) is also correct

ALTER TABLE employee

ADD CONSTRAINT CK_minit

CHECK (minit BETWEEN 'A' and 'Z' OR minit = ' ')

3) almost works (allows a ',' into the field)

ALTER...