I need the SYSTATES_SQL.MSL file.
I recovered from a disk failure and this file does not exist and I have no backup. If you can reply with this I would appreciate it.
Thanks!
Does anyone know an easy way to turn off serial/lot in IM when you already items that have have serial/lot info. We want to just disregard all this info and not have to zero out everything manually.
Is there a way to automatically report labor everytime you receive an item. Like if you were going to stick a new label on an item every time you receive one. I know you could do it in SF but that would be alot of entries.
This is a 2 parter for you.
1. To determine who has what locked:
In Query Analyzer type or paste this in:
use msllockdb
go
select sessionid, tablename, rowid from maclocks
exec sp_who
2. To clear the Buyer/Planner lock if it is caused by an abnormal exit:
In Macola: System...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.