May 8, 2012 at 10:57 am
I want to do something like this..
When i execute this query below i want to know if gives filegroupid column in the result set. I want to write some logc based on that using IF case.
exec master.dbo.xp_restore_filelistonly @filename ='\\Backups\test.bak'
Just so you know older versions do no have filegroupid but new version of litespeed software has this, so i want to verify backup for any version.
May 11, 2012 at 5:51 am
If it's not an extended SP then you could try something around capturing the results of sp_helptext in a temp table, then querying that for 'filegroupid', and basing your logic on that? Might not be what your after but thought i'd at least suggest something.
May 11, 2012 at 6:09 am
If the xp your are executing is a litespeed xp, you may get better answers on a Quest forum than here. I have very limited exposure to litespeed so I know that I won't be of much help. Not saying others here won't be, just suggesting a second avenue of research.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply