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.
| Author |
Topic |
|
ratcho
Starting Member
18 Posts |
 Posted - 2002-09-18 : 11:09:33
|
| Hi everyone,I would like to ask you if there exists the notion of priority in SQL Server 2000.For exemple, I have a lot of stored procedures and I want some of them to be executed with higher priority then the others.I wonder also if it will be possible to stop executing a stored procedure if some of the users start a query and execute the query first (with priority higher than the stored procedure).Any help will be appreciate!Thanks a lot! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-18 : 12:31:28
|
| It's not built-in to SQL Server, but you can change the priority of executing threads. It requires some code that you can find inThe Guru's Guide to SQL Server Stored Procedures, XML, and HTMLby Ken Henderson.This is the best book you can possibly get on the title's subjects, and all of the code in the book comes with the CD. He has an example of an extended procedure that allows you to manipulate the priority of a thread/procedure. You can find out more about this book through the SQL Team Bookstore. |
 |
|
|
ratcho
Starting Member
18 Posts |
Posted - 2002-09-18 : 13:16:13
|
| Thanks a lot, robvolk! I really appreciate your advice and your time!Thanks! |
|
|
|
|
|
|
Priority