Re: Create trigger - do users need to be out?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 6 Jul 2006 22:42:21 +0000 (UTC)
rdraider (rdraider@xxxxxxxxxxxxx) writes:
I created and successfully tested a trigger on a test database. Now
that I want to put this on a production system, the create trigger
statement takes way too long to complete. I cancelled after a few
minutes. The test trigger took just a second to create. The test and
production databases are identical in design. Only difference is that
there are users in the production system.
Does the trigger by chance access a linked server?
Else, I guess it could be blocking from a running query. Use sp_who
to determine if you have any blocking. The Blk column is non-zero if
the spid on the row is blocked. Blk is the spid of the blocker.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Create trigger - do users need to be out?
- From: rdraider
- Create trigger - do users need to be out?
- Prev by Date: Re: sequence of columns and preformance
- Next by Date: Re: sequence of columns and preformance
- Previous by thread: Re: Create trigger - do users need to be out?
- Next by thread: MS-SQL one .NDF file missing How to Recover/Rebuild DB??
- Index(es):
Relevant Pages
|
