sp_provider_types_rowset and some other stored procedures keep being executed
- From: "dragooon" <dragooon@xxxxxxxxxxxxxxxxx>
- Date: Sat, 5 Aug 2006 17:57:13 -0500
We recently experienced a very interesting problem. When connecting to SQL
Server 2000 (SP4) using ADO, after the recordset is retrieved, we can see
the following stored procedures kept being executed every we submit an
update query. This is what we saw in the tracing file:
-------------------------------------------------------------------------
....
[submit an update query and maybe some other querys]
exec sp_provider_types_rowset NULL, NULL
exec [dbname]..sp_tables_rowset;2 NULL, NULL
exec [dbname]..sp_columns_rowset N'tablename', NULL, NULL
exec [dbname]..sp_columns_rowset N'tablename', NULL, NULL
[submit an update query and maybe some other querys]
exec sp_provider_types_rowset NULL, NULL
exec [dbname]..sp_tables_rowset;2 NULL, NULL
exec [dbname]..sp_columns_rowset N'tablename', NULL, NULL
exec [dbname]..sp_columns_rowset N'tablename', NULL, NULL
....
------------------------------------------------------------------------
What may be causing those stored procedured to be exectued all the time?
There is little docmentation on those stored procedures anywhere...:(
.
- Prev by Date: xp-sendmail ...does it store outbound emails in a table? if so what table?
- Next by Date: Re: xp-sendmail ...does it store outbound emails in a table? if so what table?
- Previous by thread: xp-sendmail ...does it store outbound emails in a table? if so what table?
- Next by thread: Re: SQL 2000 EntMgr & SQL 2005 Management Console
- Index(es):
Relevant Pages
|
Loading
