Adi Cohn
3/9/2007 6:11:00 AM
On Mar 8, 9:47 pm, Bill Scrivener <Bill
Scrive...@discussions.microsoft.com> wrote:
> I have used xp_getfiledetails on SQL2000 for several years. Now that we are
> upgrading to SQL2005, I find out that xp_getfiledetails is no longer
> supported.
>
> Has anybody found a workaround for this? If so, will you please share.
>
> Thanks in advance.
xp_getfiledetails was an undocumented extended stored procedure. As
with all undocumented objects, they can disappear or change there
behavior at each version or even after service pack and hot fix
installation. Apparently this is what happened with xp_getfiledetails
and SQL Server 2005. There might be a new way to check file's
details, but I'm now aware of any. Fortunately there are ways around
it. You can write your own CLR function that gives you file's details
or you can use xp_cmdshell with DIR command to get the details.
Adi