remove company script 1

[Alcar]

I know there are some posts about removing a company via GP but I am in a situation where the DB has already been deleted from the Sql Server butt he company is still showing in GP.

Wasn't there a nice SQL script that could take care of this?

I can't find it...

Daren J. Lahey
Programmer Analyst
FAQ183-874 contains Suggestions for Getting Quick and Appropriate Answers to your questions.

 

[jymm]

just go into Dynamics for a company that you are NOT wanting to delete and hit Tools->Utilities->System then select Delete Company

seems this happened to me once and this took care of it - let me know if not & I will go back and look at our issue system.

 

[RobertC22]

My quick and dirty method is to backup the smallest company database. Restore this as the 'deleted' company, then use the Delete Company option within Great Plains.

A database does NOT need to exist in SQL Enterprise Manager for you to have to restore over it!

------
Robert

 

[winthropdc]

Have a look at this KB. There is a script to remove the orphaned records at the bottom of the article.

"How to delete a company in Microsoft Dynamics GP and in Microsoft Great Plains when these products are used together with SQL Server"

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;855361

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.

 

[Alcar]

Thank you David,

that was the script that I was looking for.
Running a quick backup (just in case) before running the script.

ta ta!

Daren J. Lahey
Programmer Analyst
FAQ183-874 contains Suggestions for Getting Quick and Appropriate Answers to your questions.