Give it a try :

DECLARE @Sample

TABLE (

account INTEGER NOT NULL,

...

And obviously if your MSSQLSERVER service uses a domain account to log on at startup than you need to take care of that also. 🙂

You can try this one :

SELECT DATABASE_NAME,

PHYSICAL_DEVICE_NAME AS BACKUP_LOCATION,

BACKUP_SIZE,

BACKUP_START_DATE,

BACKUP_FINISH_DATE ,

BACKUPTYPE =CASE TYPE WHEN 'D' THEN 'FULL DATABASE BACKUP'

WHEN 'I' THEN 'DIFFERENTIAL BACKUP'

WHEN 'L' THEN 'LOG BACKUP'...