xp_cmdshell is now locked out ...

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by mops33 » xp_cmdshell is now locked out ...

xp_cmdshell is now locked out ...

Rate Topic

Display Mode

Topic Options

Author

Message

gabriel.defigueiredo

Posted Monday, April 27, 2009 11:05 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, March 07, 2013 7:20 PM
Points: 15, Visits: 128

As xp_cmdshell is generally not available (unless one enables it, which some companies frown upon), a possible replacement for the code that checks for file existence is using xp_fileexist. Therefore the lines in between "temp proc to check backup file existence" become:

-- START create temp proc to check backup file existence
CREATE PROCEDURE dbo.#prFileExists
@path varchar(300) ,
@p2 int OUTPUT
AS BEGIN
IF object_id('tempdb..#cmdshell') IS NOT NULL
DROP TABLE #cmdshell
CREATE TABLE #cmdshell ([File Exists] int, [File is a Directory] int, [Parent Directory Exists] int)
INSERT INTO #cmdshell exec master..xp_fileexist @path

SELECT @p2 =[File Exists] from #cmdshell
END
GO
-- END create temp proc to check backup file existence

Post #705510

« Prev Topic | Next Topic »

Permissions