If you try to call PrepareDatabaseforDataFresh on Sql Server 2005, you'll get an error that looks like this:
Msg 15501, Level 16, State 1, Procedure xp_cmdshell, Line 1
This module has been marked OFF. Turn on 'xp_cmdshell' in order to be able to access the module.
It's not hard to turn it on. However DBAs at my company don't want to turn it on even on test DBs :(.
I told them that I can turn it on by code just before I call PrepareDatabaseforDataFresh and then turn it off after. But they don't want to hear that.
Is there anything else I can do to create a snapshot for DataFresh?
Thank you