What is this?

• htt

  SSCertifiable

  Points: 5242

  More actions

  May 28, 2003 at 1:03 pm

  #82106

  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.

• bbychkov

  SSCrazy

  Points: 2206

  More actions

  May 28, 2003 at 2:39 pm

  #458917

  It's just the way how ADO queries SQL Server. To find more about sp_cursor sp look at "System Stored Procedures" in Books-On-Line. There is a section on sp_cursor... Sps at the bottom of the article.