Hi,
I'm running SQL Profiler on an SQL Server 2000 database. I see that one
stored procedure gets repeatedly executed having a handle of '1'. This
query takes a long time to complete.
How do I find what the text of the stored procedure is? I cant see any
handle being created (using sp_prepare) with an id of '1' in the
profiler. Is there any way to force the server to re-prepare all
statements so that I can see the statement text and its preparation in
SQL Profiler?
Re: slowing/halting stored procedure from ado.net ... calling the same stored procedure from SQL> Management ... > Studio goes without any slowdown, ... > There was/is no big job running on the sql server,... >> Erratic performance of any query is usually due to something changing. ... (microsoft.public.dotnet.framework.adonet)
Re: Database Engine Tuning Advisor suggestion to replace syntax. ... Actually, what I said was "IF this code is running in a stored procedure",... execution with the execution plan generated for the first execution. ...SQL Server does not have to compile the second statement." ... replace query 1 below with the syntax in query 2 below. ... (microsoft.public.sqlserver.tools)
Re: SQL Server - Filter ... Happy to use a stored procedure but prefer to use a View that can be linked ... >> the sql server tables from access you are pretty much defeating the idea ... > many fewer bugs if they'd just used Access queries for the most part. ... > to query data from the back-end. ... (comp.databases.ms-access)
Re: Database Engine Tuning Advisor suggestion to replace syntax. ...query in my query 2 example. ... Tibor Karaszi, SQL Server MVP... Actually, what I said was "IF this code is running in a stored procedure", not "BECAUSE this ... statement in the second execution with the execution plan generated for the first execution. ... (microsoft.public.sqlserver.tools)
Re: ADP Help ... And the stored procedure would be something like: ... > this, if all the SQL statements are on the SQL Server, how would the SQL ... I use that query as a base ... >>> query for almost all of my reports.... (microsoft.public.access.adp.sqlserver)
