question

anandgu avatar image
anandgu asked

sometimes xp_cmdshell showing null

Hi sometimes xp_cmdshell showing null and sometimes its working fine... i dont know what wrong with this Any suggestions
sqlsql-server-2012xp_cmdshell
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image David Wimbush commented ·
It depends what command you are executing with it. You have not really provided enough information to help. Can you show some code?
1 Like 1 ·
KenJ avatar image KenJ commented ·
@David Wimbush is right on. Some commands would return null by design. You may be using one of these. For example... exec master.dbo.xp_cmdshell N'dir > nul';
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.