+1

Given answer is wrong, Sql server will give error on given procedure.

because "Column" is a reserved keyword and needs to be delimited if you want to use it as a...

Including SQL 2012 (In the Explanation "As of 2014"), The severity is set to 16.

We will get up to 20 different values depends on the database and sql version. So the answer should be 20

However, the explanation as to why 2 is the correct...

--this script will give you more details like who restored and backedup....

SELECT

DatabaseRestoredTo = RH.destination_database_name,

TimeOfRestore = RH.restore_date,

UserImplimentingRestore = RH.user_name,

RestoreType = CASE RH.restore_type WHEN 'D' THEN 'Full DB Restore'

WHEN 'F' THEN 'File...

Check this article

http://support.microsoft.com/kb/2545989

recycle SQL also fix the issue, with out changing the service account top local and service account