Gail,

We both changed our original posts that pointed to the opposite thread so now both are available. I'll point the other thread to here again.:-D

This may not actually be an issue, check out this article.

Gail beat me to it on the other post. I was pointing people to the other post while she was pointing people here, so I have edited mine to...

Check out the articles I included as they will help you understand deadlocks and how to troubleshoot and correct them.

You haven't done anything wrong. By default EM only displays objects for the users default database when opening a linked server node. You should be able to query...

I suggest you enable trace flag 1222 so the deadlock information is output to the error log, then you will be able to see what process the package is conflicting...

I think this is what you want:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROC [dbo].[sp_product_search]

@ProductId NVARCHAR(100),

@CrossReference NVARCHAR(100),

@ProductDescription NVARCHAR(300)

AS

...

Bob Hovious (3/16/2009)

---

If the awarding judges don't know what's technical and what isn't, then the MVP award should definitely not be confused with technical competence. Surely this isn't...

Steve Jones - Editor (3/16/2009)

---

The award is supposed to include lots of technical merits, but I'm not sure that the judges know what is technical and what isn't. I think...

Just as long as they don't spoil the whole batch!:P

I would hope that you were hired because they recognized a need for better database management, so I'd start by putting together a list of issues that you believe need...

SQL Server has a function ServerProperty() that you can use to get this information. I know it is available from at least 2000 forward.

Without a log reader, and depending on the backup plan you may not have that row in the transaction log anymore, you would need to restore the database to a...

Regular maintenance is definitely a good idea, but many times the default configuration of maintenance plans is more maintenance than is actually necessary. Kimberly Tripp just wrote an excellent...

I don't know why the configuration of the SQL Server would affect the memory usage of another server. It sounds to me like some tuning and re-configuration of the...