Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GPGuy
  • Order by date
  1. GPGuy

    SOP locked by other user

    We have GP8 and sometimes a user account will not log out properly and release any locks. Try running the following Query from your company database: -- RUN THIS QUERY TO VIEW ANY SALES TRANSACTION LOCKS SELECT tempdb.dbo.DEX_LOCK.table_path_name, master.dbo.sysprocesses.loginame...
  2. GPGuy

    Duplicate company DB to new company??

    How are you doing the backup/restore, through GP itself or, SQL Studio? If you are use SQL studio and can successfully Restore your old company into a new database, you'll want to run the SQL code below, as that updates the DYNAMICS database with reference to the new company database: --...

Part and Inventory Search

Back
Top