Vista - executing sql stored procedure

Hi,

I would like to know if it possible to have a login vbs script that
picks up the username and computer name and then passes this into to a
stored procedure that exists on a mssql 2005 box.

I had the syntax of

dim network

set network = wscript.createobject("wscript.network")

Set WshShell = WScript.CreateObject("WScript.Shell")

Set WshSysEnv = WshShell.Environment("PROCESS")


'The server name is SERVER the database is DB and the proc is
SQLStoredProc

WshShell.Run "osql -S SERVER -E -Q""EXEC DB..SQLStoredProc
Network.username,network.computername"" "

but I understand that oqsl does not work with sql2005 and I cannot get
sqlcmd to work in the same manner.

I hope someone can come to my rescue.
Ta

november_hotel wrote:Use ADO.
http://groups.google.com/group/micro...fedf4e1efd63a6
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"