Passing parameters by Name rather than position
- From: "John Faris" <johnfaris@xxxxxxxxxxxxxxxxxx>
- Date: 26 Sep 2005 04:04:32 -0700
Hi all.
I am using a TAdoStoredProc to execute sps on a SQL Server 2000 DB. The DBAs tell me it would really help them if they could profile the sp calls in SQL Profiler and see the names of the parameters rather than just a comma delimited list of the parameter values e.g. instead of
exec GetNTUser -1, 'john.faris'
they want to see
exec GetNTUser @ContactDeptId=-1, @NTUserName='john.faris'
Is this possible at all?
TIA.
.
- Prev by Date: Re: Unprepare an TADOQuery?
- Next by Date: Re: ADO failing on XP - untangling MDAC and Jet DLLs
- Previous by thread: Unprepare an TADOQuery?
- Next by thread: Why is this throwing a primary key violation!!?!?
- Index(es):
