Question of the Day

Re: QOD 2006-10-12

xmldeveloper — Mon, 06 Nov 2006 18:24:37 GMT

Specificatia N este folosita pentru a specifica faptul ca sirul care urmeaza este UNICODE.

crestinul — Mon, 06 Nov 2006 17:16:26 GMT

Imi puteti spune va rog care e semnificatia "N" din dreapta =?

Multumesc

xmldeveloper — Tue, 17 Oct 2006 06:51:29 GMT

You can filter for a specific database using the following code sample:

SELECT

TOP 1

FROM msdb..restorehistory

WHERE destination_database_name = N'AdventureWorks'

AND TYPE = 'D'

ORDER BY restore_date DESC

-- Type D stands for database

-- Other types: F = File, G = Filegroup, I = Differential

-- L = Log, V = Verifyonly, R = Revert

ggciubuc — Mon, 16 Oct 2006 19:11:04 GMT

The answer is :

select * from msdb..restorehistory

ggciubuc — Thu, 12 Oct 2006 11:35:34 GMT

How can you see the last restore (NOT backup) date of your database ?

(At this kind of question in a day I answer in other day you answer, today is a day when you can answer)