Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
use118
Starting Member
3 Posts |
 Posted - 2005-06-02 : 04:43:47
|
i am looking at performance troubles we are having with our SQL Server 2000 box. Looking at long running / CPU intensive queries using Profiler the sp_datatype_info stored procedure gets used an awful lot by one of our VB6 applications. It is not called explicitly in the code. Anyone any idea what calls it? All I can think is that the ODBC driver is using it. Any suggestions other than throwing myself/the server out the window gratefully receivedTa |
|
|
b74smith
Starting Member
3 Posts |
Posted - 2005-06-02 : 12:58:46
|
| perhaps using ADO stored procs without supplying Params (in vb6)? |
 |
|
|
use118
Starting Member
3 Posts |
Posted - 2005-06-03 : 09:28:57
|
| Might be worth a go. The App is using RDO but we've just rolled out XP clients (which have new SQL Drivers). I'm thinking that that may be the cause. Although maybe I should be worrying that a SQL system stored procedure is showing up as a long running thing?Thanks for your postAndy |
|
|
|
|
|
|
sp_datatype_info used by ODBC driver?