Quote:> In sp how can I know how many records be updated after a update sql?
HTH
--
Gianluca Hotz
Backoffice MVP (SQL Server) MCP SQL Server and MCP Windows
Vice-President of the Italian User Group for SQL Server
Founding Member of the Italian User Group for .NET
http://www.ghotz.com
http://www.ugiss.org
1. SP:ExecContextHit,SP:CacheMiss
Hi All
I've been reading and thinking (always dangerous combination) and
decided I want to show the following measures in a profile trace (as
well at statement starting etc etc )
SP:ExecContextHit,SP:CacheMiss,SP:CacheInsert
But I cant see how I dod this in profiler or find a mention of
them,,foudn them in bol but thats it
Any help (been a long day ) would be great
cheers then Simon
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
2. VB? how to inner join two tables in two MS Access database
3. SP Question - Insert into table using generic insert SP
4. FileMaker WebPublishing Made Easy
6. Advances in Digital Libraries'96: Preliminary Call for Papers
7. Return 3 values from SP to SP
8. call remote server SP from SP
9. using a sp return value within another sp
10. Process sp Result Set Within an sp?
11. SP Union SP?
12. How can I call a SP inside a SP without the owner name