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.

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 ·
@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.