Re: Types of locks occurring during Maintenance Plan
From: Paul S Randal [MS] (prandal_at_online.microsoft.com)
Date: 09/02/04
- Next message: Paul S Randal [MS]: "Re: creaet cluster index will rebuilt all non-clustered indexes in DB?"
- Previous message: Steve Thompson: "Re: Importing Access 2000 queries"
- In reply to: arman: "Re: Types of locks occurring during Maintenance Plan"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 12:11:12 -0700
Is the table being reindexed an indexed view involving one of the tables
being updated?
-- Paul Randal Dev Lead, Microsoft SQL Server Storage Engine This posting is provided "AS IS" with no warranties, and confers no rights. "arman" <armandov@optonline.net> wrote in message news:f44fe3d7.0409011627.7c9bc952@posting.google.com... > Thank you all for the quick responses, but neither foreign key or triggers exist. > > Arman > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in message news:<#p6NTvAkEHA.2908@TK2MSFTNGP10.phx.gbl>... > > Good point, Andrew. More likely (assuming the bulk load is done so it fires triggers...). > > > > -- > > Tibor Karaszi, SQL Server MVP > > http://www.karaszi.com/sqlserver/default.asp > > http://www.solidqualitylearning.com/ > > > > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > > news:%23TeRIS9jEHA.2908@tk2msftngp13.phx.gbl... > > > Or perhaps a trigger? > > > > > > -- > > > Andrew J. Kelly SQL MVP > > > > > > > > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in > > > message news:ulWUte4jEHA.4068@TK2MSFTNGP10.phx.gbl... > > > > SQL Server put exclusive locks on tables and indexes during DBCC > > DBREINDEX. Perhaps foreign key relationships > > > > causes this? > > > > > > > > -- > > > > Tibor Karaszi, SQL Server MVP > > > > http://www.karaszi.com/sqlserver/default.asp > > > > http://www.solidqualitylearning.com/ > > > > > > > > > > > > "arman" <armandov@optonline.net> wrote in message > > news:f44fe3d7.0408311015.20b9cbff@posting.google.com... > > > > > Hello, > > > > > > > > > > Can anyone tell me the types of locks happening during a maintenance > > > > > plan? I have an update process that is running from an sql server > > > > > through a linked server. And that linked server is running a > > > > > maintenance plan created through the wizard. When you view the table > > > > > that it is currently reindexing, it is not a table that is being used > > > > > in the update query. Yet the update process continues to fail with > > > > > timeout expire #7312. > > > > > > > > > > I would greatly appreciate if someone had any thoughts or ideas > > > > > regarding this problem. > > > > > > > > > > Thanks! > > > > > Arman > > > > > > > > > > > > > >
- Next message: Paul S Randal [MS]: "Re: creaet cluster index will rebuilt all non-clustered indexes in DB?"
- Previous message: Steve Thompson: "Re: Importing Access 2000 queries"
- In reply to: arman: "Re: Types of locks occurring during Maintenance Plan"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
