Log Shipping – NORECOVERY vs. STANDBY mode

 

SELECT c.action, o.name, b.name 
FROM sys.objects o
INNER JOIN sysprotects c
      ON o.object_id = c.id
INNER JOIN sysusers b
      ON c.uid = b.uid
WHERE o.type IN ('U','P','V')
AND b.name = 'LoginName'