PRINT statement in Stored Proc SQL Server 2005
Home > IT Answers > SQL Server > PRINT statement in Stored Proc SQL Server 200...
Jsql
140 pts.
0
Q:
PRINT statement in Stored Proc SQL Server 2005
SQL Server 2005, SQL Server stored procedures
Does PRINT statement in stored proc cause network traffic or any performance issues?

Can i get some tips to write good store proc that gains performance.

 

Thanks.

ASKED: Aug 12 2009  6:27 AM GMT
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
PRINT statements do use network traffic, but unless you have a lot of PRINT statements they won't effect anything.
Last Answered: Aug 12 2009  7:16 AM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Jsql   140 pts.  |   Aug 12 2009  8:07AM GMT

Thanks Denny

 
0