Tim,

If I remember correctly you must use the WITH LOG option in you RAISERROR command in order for the alert to be triggered.

Gregg,

as already said before you cannot disable xp_regread through sp_configure. While sp_configure works for xp_cmdshell, most others you can only deny execution rights to your users.

But I have to...

tjad and Shehap

thank you both for your responses. I'm longer working at the customer where we had this issue, so I won't be able to do anymore testing, but both...

dallas13 (9/28/2009)

---

Hello I have this version of SQL 2005

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise...

First of all I wonder why you ask us and not MS for the "offical response".

But there are actually several responses from MS, because there are also different reason...

You can start SSMS with the runas option and then use another windows login.

Unless you have any applications which require a fixed port I would recommend to use dynamic port settings. If...

I suggest you start reading this about deadlocking.

Once you understand deadlocking you can get more information about what is causing the problem by either enabling traceflag 1204 or 1222 or...

I'm pretty sure I answered you're first question already a while ago.

http://www.sqlservercentral.com/Forums/Topic783680-146-1.aspx#bm783727

If this was not clear enough let us know.

And to answer your second question yes you can use...

On a active-active cluster at least one of the instances must have a port other than 1433. If both instances would use the same port, a conflict would occur during...

When the RTM version of SQL 2500 was released DB Mirroring was not "ready yet" and so MS decided to disable it. You could enable mirroring by setting the 1400...

When you restore a backup of a database to a different server all string columns will keep the collation of the original database. In your case I suspect that the...

jonathan allen (9/1/2009)

---

Hi,

I'm a little late to this but am trying to get a baseline CPU trace of one of my servers and found the thread.

Can anyone advise me whether...

You cannot be serious.

How do you expect us to help you with that little information.

If this really was the statement you executed, then change it to:

Alter Endpoint [TSQL Default TCP] set...