XP_GetFileDetailsAlternative on 2005

Question

Post reply

XP_GetFileDetailsAlternative on 2005

CrazyMan

SSChampion

Points: 12560
More actions
November 18, 2008 at 4:49 am

#132213

Hi All
I need to get information of a file from T-SQL, i used this SP on 2000 but this is not been found on 2005, is there any alternative for this procedure. i need to get the file size and file date when the file has been created.
Thanks in advance
Cheers
🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

it's gone in sql2005 ... it was undocumented .... so shouldn't have been in use ...

check out :

- http://forums.databasejournal.com/showthread.php?t=41753

- http://www.simple-talk.com/sql/learn-sql-server/building-my-first-sql-server-2005-clr/

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

CrazyMan SSChampion Points: 12560 More actions · Answer 2

i tried mate, it says could not find store procedure, i am using SQL 2005 64 bit, does this make any difference 🙂

I will check the forum as well, please let me know if there are any more places i have to check

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

system xprocs or sprocs are equal for 32bit and 64bit.

As mentioned by the urls, you'll have to build your own version.

If doing it using xp_cmdshell, encapsulate it in a sproc that runs as sp_cmdshell authorised user, so you don't end up a completely open cmdshell.

pro is that you don't have to open clr.