Showing posts with label port. Show all posts
Showing posts with label port. Show all posts

Sunday, March 25, 2012

Deadlock with Port: 0

I've been diagnosing deadlocks for a last couple weeks at a client site and I understand the KEY: and TAB: locks issues. However, the client recently experienced a series of multi-branch deadlocks for which I can find no information. Attached is the deadlock text from the ERRORLOG. Any help would be much appreciated.

NickHave you tried to capture deadlocks with the profiler ? It is surely clearer than errorlogs.|||Unfortunately I don't have access to the production system this is running on. I have run profiler traces but that still doesn't tell me anything about Port: 0.

Friday, February 17, 2012

DBMail in SQL 2005

Hi,
DBMail in SQL 2005 uses port 25. Is there way that could be changed or not?
Currently we block port 25 so am unable to use DBMail in SQL 2005
Thanks in advance......> DBMail in SQL 2005 uses port 25. Is there way that could be changed or
> not?
Yes, port 25 is only the default. You can change it when you set up an
account. Check the "Database Mail Accounts" topic in Books OnLine
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/7b758925-c59a-4015-92cb-0d4
cbfc72ea3.htm).
Although I have never tried to change the default port...
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

Tuesday, February 14, 2012

DBMail in SQL 2005

Hi,
DBMail in SQL 2005 uses port 25. Is there way that could be changed or not?
Currently we block port 25 so am unable to use DBMail in SQL 2005
Thanks in advance......> DBMail in SQL 2005 uses port 25. Is there way that could be changed or
> not?
Yes, port 25 is only the default. You can change it when you set up an
account. Check the "Database Mail Accounts" topic in Books OnLine
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/7b758925-c59a-4015-92cb-0d4cbfc72ea3.htm).
Although I have never tried to change the default port...
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/