Execute commands within tsql

Question

How can I execute system command like dir other than xp_cmdshell?

Well it simply does not work - program that sends query does not responds after that, even if command is dir that does not take time to evaluate. — seeker
– seeker, Commented May 20, 2012 at 14:20
I cannot try because i does not have direct access to server - only through that program. — seeker
– seeker, Commented May 20, 2012 at 14:27

Royi Namir · Accepted Answer · 2012-05-20 14:39:12Z

1

I dont see any problem , here is an example :

dstest is a remote server ...

enter image description here

edit

run this to activate :

EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

edited May 20, 2012 at 14:39

answered May 20, 2012 at 14:32

Royi Namir

149k145 gold badges502 silver badges833 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

seeker Over a year ago

Maybe this stored procedure(xp_cmdshell) is blocked?

seeker Over a year ago

Thanks! Even though i saw your edit in MSDN, only by reading it careully second time and executing commands one by one I achieved the desired result.

Collectives™ on Stack Overflow

Execute commands within tsql

1 Answer 1

edit

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

edit

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related