MASTER..SP_EXEC_CMD

Henrique silva freitas

unread,

Jun 27, 2019, 5:01:26 PM6/27/19

to sqlserverdf

Galera,

Alguém já passou por esse erro:

'MASTER..SP_EXEC_CMD_SHELL'. The module will still be created; however, it cannot run successfully until the object exists.

--

Atenciosamente,

Henrique Silva Freitas
(61)9 9561-2169

Marcelo Kamimura

unread,

Jun 27, 2019, 5:30:10 PM6/27/19

to sqlse...@googlegroups.com

Henrique,

Voce esta executando algum alter/create procedure que faz a chamada a procedure SP_EXEC_CMD_SHELL que não existe na base master e por isso a mensagem.

Att,

Marcelo Kamimura

--

---
You received this message because you are subscribed to the Google Groups "SQLServerDF" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlserverdf...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sqlserverdf/CADqoC4J3U%2BJehnS3W_zMrRFfzu7WYMxVCZKJRWHopxox4%3DmJLQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Henrique silva freitas

unread,

Jun 27, 2019, 5:35:11 PM6/27/19

to sqlserverdf

Marcelo,

Estou executado a mesma função:

EXEC MASTER..SP_EXEC_CMD_SHELL @COMANDO, @RET OUTPUT ;

Em ambientes diferentes, na mesma versão 2012, só com patch diferentes o estranho que no outro ambiente executa sem problemas.

Versão que funciona:

Microsoft SQL Server 2012 (SP3-CU7) (KB3205051) - 11.0.6579.0 (X64)
Dec 22 2016 11:18:09
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Versão que dá o erro:

Microsoft SQL Server 2012 (SP3-CU10) (KB4025925) - 11.0.6607.3 (X64)
Jul 8 2017 16:43:40
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

Erro em questão:

Could not find stored procedure 'MASTER..SP_EXEC_CMD_SHELL'.

E não acho referência pra essa chamada no pai GOOGLE.

To view this discussion on the web visit https://groups.google.com/d/msgid/sqlserverdf/CAEAV6WA4OStdD35M6mtiOPR1672AGjUz142emF1DXBMgNTRNyw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Advaldo Mesquita

unread,

Jun 27, 2019, 6:09:56 PM6/27/19

to sqlse...@googlegroups.com

Erro em questão:

Could not find stored procedure 'MASTER..SP_EXEC_CMD_SHELL'.

Pega de um ambiente que esteja funcionando e cria onde não está

To view this discussion on the web visit https://groups.google.com/d/msgid/sqlserverdf/CADqoC4Lc7vwDmOL6SCO6vDgEhNGYMwB-1R8FD1_8%2BHg7fhpaDA%40mail.gmail.com.

Reply all

Reply to author

Forward