File Exist on a harddrive

[nikhilparchure]

Is there a comand to search if a file exists on local system
This should be some system sp I believe.

Help appreciated

Parchure Nikhil

 

[JamesLean]

xp_fileexist

http://www.sqlservercentral.com/columnists/bknight/xpfileexist.asp

--James

 

[miq]

HI,
not sp but xp :-;

Declare @code int
exec master..xp_fileexist 'c:\aaa.txt',@code output
select @code

B.R,
miq

 

[miq]

Hi,
JamesLen, nice little article. How would you ensure proper security for extended procedures?

B.R,
miq

 

[JamesLean]

Same as any other object. In EM, right-click on it and go to All tasks -> Manage Permissions. I think the Public role has default permissions on it so you may want to remove that for a start. If you did that then only sysadmin members would be able to execute it.

--James