What is the equivalent of the extended procedure 'xp_dirscan' in SQL Server 2005?
A:
xp_dirscan
seems to be an extended stored proc that performs a recursive directory search. If you have access to the DLL you could register it as an extended stored proc in SQL 2005.
Alternatively, you could code something that performs the same action using xp_cmdshell
or a managed extended stored proc.
Sam Saffron
2008-10-15 00:56:57
+1
A:
It's not native shipped code in SQL Server. It's a 3rd party extenfed stored proc (which is a DLL).
You can register on SQL Server Central and see this article with download and instructions.
It's for SQL 2000 but registering the DLL should be the same (I've not tried it on '2005)
gbn
2008-10-21 04:47:43