pradipkkoli
asked on
Want to delete Folder from store procedure
Hi,
Is there any way to delete the folder from Store Procedure in SQL Server 2000.
Kindly provide the reference or the code for the same if avaliable.
Thanks
Pradip
Is there any way to delete the folder from Store Procedure in SQL Server 2000.
Kindly provide the reference or the code for the same if avaliable.
Thanks
Pradip
Last Comment
ASKER
Hi,
I had tried to create the SP
create procedure delDir (@path varchar(8000)) as
begin
exec xp_cmdshell 'delete ' + @path
end
But there is error, the message is
Server: Msg 170, Level 15, State 1, Procedure delDir, Line 3
Line 3: Incorrect syntax near '+'.
I had tried to create the SP
create procedure delDir (@path varchar(8000)) as
begin
exec xp_cmdshell 'delete ' + @path
end
But there is error, the message is
Server: Msg 170, Level 15, State 1, Procedure delDir, Line 3
Line 3: Incorrect syntax near '+'.
try this
create procedure delDir (@path varchar(8000)) as
begin
declare @stmt varchar(8000)
set @stmt = 'delete ' + @path
exec xp_cmdshell @stmt
end
create procedure delDir (@path varchar(8000)) as
begin
declare @stmt varchar(8000)
set @stmt = 'delete ' + @path
exec xp_cmdshell @stmt
end
ASKER
tried but got another error
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'xp_cmdshell'. The stored procedure will still be created.
How to add the 'xp_cmdshell' object
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'xp_cmdshell'. The stored procedure will still be created.
How to add the 'xp_cmdshell' object
that means your dba has deleted the xp_cmdshell stored procedure
so you need to contact him and ask him what can you do
basically you could create an extended stored procedure in C language that deletes a file, but i dought that your dba will allow you to do that if he dropped xp_cmdshell
so you need to contact him and ask him what can you do
basically you could create an extended stored procedure in C language that deletes a file, but i dought that your dba will allow you to do that if he dropped xp_cmdshell
You will need to enable the xp_cmdshell from the SQL Server 2005 Surface Area Configuration.
Click on tab View by Component and enable the xp_cmdshell and you should be ready to go.
Hope this makes sense.
Cheers,
Aash.
Click on tab View by Component and enable the xp_cmdshell and you should be ready to go.
Hope this makes sense.
Cheers,
Aash.
ASKER
Hi,
I am using SQL Server 2000, how to proceed in in SQL Server 2000 for the baove step
Pradip
I am using SQL Server 2000, how to proceed in in SQL Server 2000 for the baove step
Pradip
It is enabled in SQL Server 2000 by default.
if you want to add the xp_cmdshell in case its uninstalled, Please use the below command:
exec sp_addextendedproc 'xp_cmdshell','xplog70.dll
Hope this helps.
Cheers,
Aash.
if you want to add the xp_cmdshell in case its uninstalled, Please use the below command:
exec sp_addextendedproc 'xp_cmdshell','xplog70.dll
Hope this helps.
Cheers,
Aash.
ASKER
Hi,
Thanks for the answer.
But i m not using local database, i using as a client and db is on the server. On server the command is working but not on my local pc. So what rights on server i need to give.
Thanks
Thanks for the answer.
But i m not using local database, i using as a client and db is on the server. On server the command is working but not on my local pc. So what rights on server i need to give.
Thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for the solution. Thank You.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
these commands run with the privileges of the user that runs the sql server service
so basically you can create a stored prcoedure like this :
create procedure delDir (path varchar(8000)) as
begin
exec xp_cmdshell 'delete ' + path
end