List of stored procedures

[SolarCity]

Does anyone know where I can find the full list of stored procedures? I'm
interested in getting the stored procedure name, input/output parameters, as
well as a general description of what it does.

Thanks.

[David Musgrave [MSFT]]

Most stored procedures expect to be called from Dexterity code and often
require extra steps handled by the Dexterity code to complete a process.
Unless you are very confident in a stored procedures function, it would be
unwise to call it directly.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics

mailto:***@online.microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

Post by SolarCity
Does anyone know where I can find the full list of stored procedures? I'm
interested in getting the stored procedure name, input/output parameters, as
well as a general description of what it does.
Thanks.

[Valentin PR]

Hi David:

The advice is good; but where we can find the full list of stored procedures?
We are interested in getting the stored procedure name, input/output
parameters, as well as a general description of what it does.

Regards,
Valentin

Post by David Musgrave [MSFT]
Most stored procedures expect to be called from Dexterity code and often
require extra steps handled by the Dexterity code to complete a process.
Unless you are very confident in a stored procedures function, it would be
unwise to call it directly.
David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

Post by SolarCity
Does anyone know where I can find the full list of stored procedures? I'm
interested in getting the stored procedure name, input/output parameters, as
well as a general description of what it does.
Thanks.

[David Musgrave [MSFT]]

As far as I know, there is no list such as you describe. If you had access
to the Great Plains Source Code you could find the calls to the stored
procedure entry points, but this would not cover secondary calls from one
stored procedure to another.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics

mailto:***@online.microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

Post by Valentin PR
The advice is good; but where we can find the full list of stored procedures?
We are interested in getting the stored procedure name, input/output
parameters, as well as a general description of what it does.
Regards,
Valentin

Post by David Musgrave [MSFT]
Most stored procedures expect to be called from Dexterity code and often
require extra steps handled by the Dexterity code to complete a process.
Unless you are very confident in a stored procedures function, it would be
unwise to call it directly.
David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

Post by SolarCity
Does anyone know where I can find the full list of stored procedures? I'm
interested in getting the stored procedure name, input/output parameters, as
well as a general description of what it does.
Thanks.

[Valentin PR]

Hi David:

At present I don’t have access to the Great Plains Source Code, but it is an
alternative.

Thanks for the response.

Regards,
Valentin

Post by David Musgrave [MSFT]
As far as I know, there is no list such as you describe. If you had access
to the Great Plains Source Code you could find the calls to the stored
procedure entry points, but this would not cover secondary calls from one
stored procedure to another.
David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

Post by Valentin PR
The advice is good; but where we can find the full list of stored procedures?
We are interested in getting the stored procedure name, input/output
parameters, as well as a general description of what it does.
Regards,
Valentin

Post by David Musgrave [MSFT]
Most stored procedures expect to be called from Dexterity code and often
require extra steps handled by the Dexterity code to complete a process.
Unless you are very confident in a stored procedures function, it would be
unwise to call it directly.
David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

Post by SolarCity
Does anyone know where I can find the full list of stored procedures? I'm
interested in getting the stored procedure name, input/output parameters, as
well as a general description of what it does.
Thanks.

[Patrick [MSFT]]

For Dynamics & our 3rd party apps, on the machine you did the "server"
install on there is a SQL folder. In there, by product, are a bunch of
different files. Some are data (.out) but others are .cmp or .sys I think
it is.

Anyway, we load the Dynamics stored procedures from there as well as the
company ones. It would be procs.cmp & procs.sys. There are the "create
proc as" procedures so you can see it all in readable format. there isn't
any descriptions for anything however.

patrick
developer support
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Post by Valentin PR
The advice is good; but where we can find the full list of stored procedures?
We are interested in getting the stored procedure name, input/output
parameters, as well as a general description of what it does.
Regards,
Valentin

Post by David Musgrave [MSFT]
Most stored procedures expect to be called from Dexterity code and often
require extra steps handled by the Dexterity code to complete a process.
Unless you are very confident in a stored procedures function, it would be
unwise to call it directly.
David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

Post by SolarCity
Does anyone know where I can find the full list of stored procedures? I'm
interested in getting the stored procedure name, input/output parameters, as
well as a general description of what it does.
Thanks.