Re: Table Locking

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/14/04 

Date: Sat, 14 Feb 2004 10:36:22 -0500

I am still not sure if your asking if this is necessary or that you actually
need to do this. That's usually not a good thing to do and is certainly not
necessary just to run a stored procedure. Again if you give more details on
what it is your trying to accomplish we might be able to provide some help. 

-- 
Andrew J. Kelly
SQL Server MVP
"Thomas" <anonymous@discussions.microsoft.com> wrote in message
news:6851B52C-AC1D-4697-80E7-C360E025C45B@microsoft.com...
> I mean locking the entire table, till the end of the running of the
procedure, I am calling some other procedure within this proc.
>
>
> Thanks

Relevant Pages

  • Re: Passing a named function instead of a code block?
    ... grab a method as an object without calling it, ... :square1 is an atomic unit representing the symbol whose ... we call square1 and cast the result of that using '&'. ... '&square2' is fine as square2 is just a variable referring to a proc. ...
    (comp.lang.ruby)
  • SQL Task Error in proc not detected?
    ... I have a package calling a stored proc PROC1, ... proc PROC2, ...
    (microsoft.public.sqlserver.dts)
  • Re: Using output variables
    ... The problem lies in the Web page that calling ... DECLARE @permission int ... EXEC GetPermissions @PID,@UserID,@permission OUTPUT ... > I have the Page calling the stored proc and the proc ...
    (microsoft.public.sqlserver.programming)
  • Re: OT: Calling All Luddites
    ... >>>Calling All Luddites ... >>>By THOMAS L. FRIEDMAN ...
    (talk.origins)
  • Re: Sachertorte needed
    ... > Calling Mrs T. Calling Mrs T. ... > Nice to see Bryn's got an almost decent haircut in preparation for the ... I prefer his hair longer. ... Thomas was gorgeous. ...
    (rec.music.opera)
Quantcast