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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- GPGuy
- Post #3
- Forum: Microsoft: Dynamics GP (Great Plains)
-
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: --...- GPGuy
- Post #2
- Forum: Microsoft: Dynamics GP (Great Plains)
