I have IIS and SQL on separate boxes. Using profiler I catch this line very often:
quote:
declare @P1 int
set @P1=180150000
declare @P2 int
set @P2=8
declare @P3 int
set @P3=1
declare @P4 int
set @P4=583
exec sp_cursoropen @P1 output, N'Select ..........', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4
I run this in QA, the result is nothing useful. I asked the developers but they donlt know why IIS sends the line to SQL. They just write the SELECT statement. This query is seen quite often with same P1, P2, P3, P4 and their values. Do you know what it is and why IIS sends them to SQL?
Thanks.