deadlock victim

h
im the below output from profiler..processes r getting deadlock and most of the time the below processes spid is causing blocking..but im unable to get procedure associated with that...
RPC Event 0 sp_executesql;
wot is sp_executesql;1 ?There are some trace falgs you can turn on to help resolve deadlocking
problems.
DBCC TRACEON (1204, 3605,-1)
will output info into your SQL Server ErrorLog.
--
HTH
Ryan Waight, MCDBA, MCSE
"sanjay" <anonymous@.discussions.microsoft.com> wrote in message
news:B1BF5BC8-8889-4054-9FDD-1FE3B52418B9@.microsoft.com...
> hi
> im the below output from profiler..processes r getting deadlock and most
of the time the below processes spid is causing blocking..but im unable to
get procedure associated with that...
> RPC Event 0 sp_executesql;1
> wot is sp_executesql;1 ?
>|||h
thnks for yr reply..but i failied to identify which the procedure associated with this...RPC Event 0 sp_executesql;
this "RPC Event 0 sp_executesql;1" im in getting profiler as deadlock processes

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/

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/