Stored Proc Failed To Kill User Connections?

Hello:

I am working with an application unde mssql 6.5 ,sp4. We have a separate
database for reporting on a different box. Each night we load a backup into
the database from the production database.

I set up a stored procedure to kill all users connected to this reporting
database just before the load.

THe job looks like this under scheduled tasks as a cmdexec:

isql -U sa -P -d master -Q"exec killusersall_sp 7" -o
F:MSSQLatchjobs
evdb.log


This job died with the following message:


Process Exit Code 1. ...[-b On error batch abort] [-O use Old ISQL
behavior disables the following]<EOF> batch processingAuto console width
scalingWide messagesdefault errorlevel is -1 vs 1 [-? show syntax summary
(this screen)]


The killusersall is paramaterize sp that I pass the dbid of the database
for whom I want all users killed. I need to put the stored procedure in the
master because I egt the spid from sysprocesses.


I do not understand why the job died. Does it matter if I named the stored
procedure as sp_killusersall instead of killusersall_sp which I used.

Can any one advise me about how to get the job to run? Any assistance will
be greatly appreciated. Thanks you.

David Spaisman