Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 xp_getfiledetails

Author  Topic 

dejjan
Yak Posting Veteran

99 Posts

Posted - 2005-09-30 : 05:00:20
Hello my friends.

I want to use this procedure to get list of files on specific folder and to see theirs size. But, my files have long names and results from this procedure gives me an alternate name which is like this 'BA7607~1.BAK'. So I can't connect these names with original.

How to solve this ?




madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-30 : 05:15:54
xp_getfiledetails is undocumented procedure
Use the method suggested by MVJ here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55812

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -