Re: Error 1203

From: Emad Sarraj (esarraj_at_nospam.nospam)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 08:03:03 -0700

I can't say it's reproducible, this stored procedure is one of several that run consecutively from a DTS package on a daily basis, the error happens on some days, and I can’t find a pattern yet.

BTW, I though Microsoft will answer these postings within 48 hours for MSDN subscribers!

"Neil Pike" wrote:

> Emad,
>
> As a workaround you could, probably, change your MAXDOP to 1 on the query or the server.
>
> It is a bug however, so, if reproducible, contact MS PSS and work with them to get a proper hotfix done.
>
> > I've been getting this error from running a stored procedure that has an "Update" statement. Everything I've read about this error so far advises to install SP1 to resolve it, but I'm at SP3.
> >
> > DESCRIPTION: Error: 1203, Severity: 20, State: 1
> > Process ID 55 attempting to unlock unowned resource PAG: 13:1:303.
>
> Neil Pike MVP/MCSE. Protech Computing Ltd
> Reply here - no email
> SQL FAQ (484 entries) see
> http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
> (faqxxx.zip in lib 7)
> or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> or www.sqlserverfaq.com
> or www.mssqlserver.com/faq
>
>

Relevant Pages

  • RE: Using a linked server
    ... Create a DTS package that does the copy and call that DTS ... package from your stored procedure ... "jaylou" wrote: ... > If the other DB is on the same physical server I know I can use: ...
    (microsoft.public.sqlserver.programming)
  • RE: Problem using GLobal Variables in DTS Package
    ... > I have created a DTS package, the data source is a stored procedure with an ... > The source connection for the transformation uses Microsoft OLE DB Provider ...
    (microsoft.public.sqlserver.dts)
  • Problem using GLobal Variables in DTS Package
    ... I use SQL 2K on a Win2K box ... I have created a DTS package, the data source is a stored procedure with an ...
    (microsoft.public.sqlserver.dts)
  • Re: Output Parameter To Global Variable (DTS)
    ... DECLARE @OutputTest1 int, @OutputTest2 int ... I am executing a stored procedure with 2 input> parameters and 2 output parameters. ... > The output params are causing me a headache. ... When I execute the DTS task, only the first output param from the> stored procedure is populated into the global variable in the DTS package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Kick off job on-the-fly
    ... so write a stored procedure that calls the DTS, ... >> I have a scheduled job that executes a DTS package. ... we want the job (which executes a package) to be kicked off. ...
    (microsoft.public.vb.general.discussion)