Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Set LOCK priority

Author  Topic  Bex Aged Yak Warrior 580 Posts Posted - 2009-03-16 : 10:37:32 I have a view that is used by an application. I want to drop and recreate the view. Is there a statement where I can set the priority of the procedure that is to drop the view over the processes that are using it? So similar to SET DEADLOCK_PRIORITY HIGH, except not for resolving deadlocks. Thanks Hearty head pats