Comments
2 comments
-
The data types are identical to that returned by the native RESTORE FILELISTONLY command (see here), except for the following:
- UniqueID, LogGroupID and DifferentialBaseGUID are varchar(36) instead of GUIDs
- IsReadOnly and IsPresent are integers instead of bits
The reason for the discrepancy is because the SQL Server extended stored procedure library does not support GUID and bit types. -
Very nice. Thank you.
-Matt
Add comment
Please sign in to leave a comment.
I'm not using all of the columns, so I defaulted to VARCHAR(100) when I wasn't sure. Here are my guesses: Thanks,
- Matt