ISQL Syntax help

Last Post 16 Oct 2008 07:00 AM by phsatech. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
phsatech
New Member
New Member

--
15 Oct 2008 05:17 PM
I'm trying to run the following stored procedure via ISQL (command line):

C:\Documents and Settings\svcpsdadm>isql -S ZRVPSS03 -U sa -P password -Q "EXEC
UTE usp_KillUsers @dbname = 'EP88PTST' " -o c:\temp\usp_kill.txt

But it errors out. I can execute the following no problem:

C:\Documents and Settings\svcpsdadm>isql -S ZRVPSS03 -U sa -P $CyPr3sS~ -Q "EXEC
UTE SP_PSWHO" -o c:\temp\usp_kill.txt

with no issue

I tried a few variations but still get the same error message "Killing Users
-----------------
Msg 515, Level 16, State 2, Server ZRVPSS03, Procedure usp_KillUsers, Line 15
Cannot insert the value NULL into column '', table ''; column does not
allow nulls. INSERT fails.
The statement has been terminated.
Done

Appreciate insight into the missing syntax
phsatech
New Member
New Member

--
16 Oct 2008 07:00 AM
Yes it does
phsatech
New Member
New Member

--
26 Oct 2008 05:11 PM
thnxs I managed to get it using oslq last week, the only issue was i was able to append the action to an existing log file ie. >>sql.log that records all the various actions from shutdown to refresh. But no worries.
You are not authorized to post a reply.

Acceptable Use Policy