Execute commands within tsql

Question

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

Answer 1

I dont see any problem , here is an example :

dstest is a remote server ...

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