Help Locating Corrupt File

[BuckChef]

I am using a Res 3700 and suddenly at the end of an evening a (corrupt check?) made a terminal crash, I tried to pick the cheek up at another terminal and it made that terminal crash. The Split checks are still there, but whatever terminal they are at is not able to load past "loading one checks" portion of the start up.
I am assuming I must find the corrupt file but have no idea how to locate it, could someone please offer some assistance with this.

 

[Wildbar]

Look for a thread on here how to find and force a check closed using SQL. If you cant find it ill repost.

 

[BuckChef]

Couldn't find anything on it, if it's possible to repost that would be awesome!!!

 

[Wildbar]

To correct this problem do the following:

Open dbisql

type the following sql script

Select * from micros.chk_dtl
where chk_open = 't'
order by chk_seq

this will only display open check from previous business and current dates that are open. (Usually you are looking for a check from a previous day)
right down the chk_seq # (compare what check are still open)

now run another sql script

call micros.sp_forcechkclose (insert chk_seq # here)

 

[BuckChef]

Where do you type the sql script?

 

[dforge]

You run "DBISQL"

Start Menu > Run > DBISQL