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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Event_Log lock

Status
Not open for further replies.

SBTBILL

Programmer
May 1, 2000
515
US
I've been looking for answers on this in the VFP form and the MTS forum. The message is usually CK_event_Log. Event_Log is an MSSQL table that was created in house to primarily track module use.

Today it got a little stranger. The error message came back as Table Check constraint 'N'OurSQLPassword_event_log' The conflict occurred in Event_log. Later we had an error saying the table couldn't be found via Query Analyzer. We went to Enterprise Manager found and browsed it.

The table exists on a server called SeneGence 6. There is a directory on this for SBT 6.0 called PRO60. It contains both a VFP6 and a VFP9 runtime. My in house programs and SBT 6 are run from it. SBT 6 is a DBF only program that does not access the Event_log. Once I got everyone out of SBT the event_log and A VB program I was looking at but not running that resides in a different directory on the same server everything started working again.
 
What's the exact error that you are getting from the SQL Server?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top