How to work with folder and File ?

[Golden Jing]

Dear All, I use SQL Server 2005. I want to creat Folder If have that folder name ready I want to rename it or delete old folder. About File is the same. Have any command for do it ? Thanks for help....

VB.Net

[Ashfield]

You need to use xp_cmdshell, but you will probably have permissioning problems! Why do file activities from sql server?

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[Niladri_Biswas]

I believe this can be done via

xp_cmdshell

In the below example I am creating a directory initially and next time if such a directory is found, I will rename that

declare
@cmdpath nvarchar(60)
, @Location nvarchar(100)
, @message nvarchar(max)
set @Location = N'C:\NewFolder'
set @cmdpath = 'MD '+ @Location

create table #result(result nvarchar(255))
insert into #result (result) exec master.dbo.xp_cmdshell @cmdpath
select @message = ISNULL(@message + ' - ','') + result from #result where result is not null
if(@message is not null)
begin
EXEC xp_cmdshell 'RENAME C:\NewFolder RenamedFolder'
end
select @message
drop table #result

For more info you can visit a) Using xp_cmdshell[^] b) xp_cmdshell[^] :)

Niladri Biswas

[Mycroft Holmes]

Why are you using SQL Server to interact with the file system, this is generally not recommended as it exposes the file system to database users. Most server environments will not allow that.

Never underestimate the power of human stupidity RAH

[Golden Jing]

thanks. the reason is that the data in backup to txt file so some have to rename, delete or create new. about Folder when delete it ask are you sure (Y/N)? how can type Y ?

VB.Net

[Mycroft Holmes]

Your statement does not make a lot of sense to me. You back up your database to a text file? Are you nuts? Ok what database are you using that does not have a backup facility to properly backup and restore your data. As someone suggested you can use xpcommand shell but it sounds like a nightmare to me. Permissioning will be another issue as well. I would recommend you TOTALLY rethink you data management.

Never underestimate the power of human stupidity RAH

[Golden Jing]

thanks you so much.

VB.Net

[Niladri_Biswas]

To be honest, though I proposed a solution, but I agree with you. If the person is using .net, it is better to go ahead with SMO. In any other technology, there must be some option to go ahead.

Niladri Biswas