I'm making enough to comfortably support a family of six and am confident I'll get a raise in May. And I've only been working with databases for about 3...

Well that was an excersice in futility. I can make the process work, but without a trigger on sysprocesses, the performance hit is very high. I just experimented...

I've discovered that. However, I think I could have made the trigger only fire when blocking occured.

Robert Marda

I'm already able to capture the spids (only the ones involved in the deadlock). I'm trying to figure out the best way to continuously scan for deadlocks. I...

Thanks for the links. I have read the article on blocking for SQL Server 7.0 and it doesn't appear to allow specific checking for deadlocks. It looks like...

As far as I know, no.

However, what we do is create a role in each database and give that role execute permissions to all stored procedures. Then we place...

My focus of concern is as continuous a check as possible and without using profiler.

These blocking scripts. Where can I find them? and do they capture all blocking...

If you are using SQL Server 2000 you should be able to use sp_repladdcloumn or sp_repldropcloumn if the table changes where for adding and/or removing columns. There might be...

Good question. I have begun to wonder this myself. When I started at bigdough.com almost all stored procedures used dynamic SQL. Gradually, I have been converting them...

I copied the CASE statements and put a SELECT in front of them and removed the DESC and ASC at the end.

Without reading up on the subject, I'd have to...

You can avoid dynamic SQL by using code like this:

DECLARE @ClientList varchar(100), @len int, @CurPos int, @PrevPos int

CREATE TABLE #ClientList (names varchar(35))

SET NOCOUNT ON

SET @ClientList = '0,1,2'

SET @len = LEN(@ClientList)...

Here is an example using the pubs database that can handle ASC and DESC in one query:

DECLARE @OrderBy varchar(10), @Sequence varchar(4)

SET @OrderBy = 'au_lname'

SET @Sequence = 'DESC'

SELECT *

FROM authors

ORDER BY...

If you know the password you could change the password. That way if someone screams, you can easily put everything back.

Another option would be to script everything related to...

I think you can fix this by using a temp table. Put all the e-mails in a temp table and then use the temp table in place of:

(select productid...

Try something like this:

CREATE TABLE #temp(equation varchar(20))

INSERT INTO #temp(equation)

exec("select equation from control where idnr=" + idnr)

Or use a permanent table to insert into.

Robert Marda