Great procedure, thank you.
If I run it on the local drive it works great.
----------
USE [master]
GO
DECLARE@return_value int
EXEC@return_value = [dbo].[GetDirDetails]
@piFullPath = N'C:\'
SELECT'Return Value' = @return_value
GO
----------
However if try to run it on a network drive no records are returned
----------
USE [master]
GO
DECLARE@return_value int
EXEC@return_value = [dbo].[GetDirDetails]
@piFullPath = N'\\ELK\Share\Dealers\'
SELECT'Return Value' = @return_value
GO
-----------
I do have security rights to read on the network drive and can browse it from the same box SQL is running on. I'm at a loss. Am I missing something here?