The second select doesn't return 2... It returns 1.

What is it???

The second select doesn't return 2... It returns 1.

What is it???

I answered 4 but i had the wrong answer.

I tested it and the response is 4.

I don't understand why the question is not tested!!

I answered SQL Server Management Studiop because in SQL Server 2008, we can change the default backup directory in it.

Select facets on the instance of SQL Server and change the...

I saw that in:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/72bb62ee-9602-4f71-be51-c466c1670878.htm

In SQL Server 2008 BOL you can read this:

In SQL Server 2008, the default location of the Resource database is <drive>:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\Binn\. The database can be moved;