RE: sp_droporphans

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 02/16/05

Next message: Uri Dimant: "Re: import accessfiles with stored procedures"
Previous message: milly: "sp_droporphans"
In reply to: milly: "sp_droporphans"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 16 Feb 2005 02:11:02 -0800

>From BOL:
The sp_createorphan and sp_droporphans stored procedures are used for ODBC
ntext, text, and image processing.

Check what users are processing at the same time agaisnt your table. You may
need to have them log off and not do anything until you finished your update.

Regards
Mike

"milly" wrote:

> Hi all!
> I have a problem.. during an update statement the database is locked by a
> process generated by the system stored procedure sp_droporphans...I wonder
> why?
>
> the statement is:
> update tableA
> set field1 = 'AA'
>
> THANKS!
>

Next message: Uri Dimant: "Re: import accessfiles with stored procedures"
Previous message: milly: "sp_droporphans"
In reply to: milly: "sp_droporphans"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Writing updates from a wide DataTable
... I would personally not use stored procedures in this case. ... You can build your own update statement. ... >following the recommendations to use stored procedures to apply updates to ... >the database, ...
(microsoft.public.dotnet.framework.adonet)
Re: newbie: how to implement vb recordsets in stored procedures
... a simple update statement will give you what ... > recordsets to a stored procedures. ... > visual basic code thes way that specify the business rules. ... > Joost. ...
(microsoft.public.sqlserver.programming)