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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Intermittent

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-10-10 : 09:31:06
francis writes "We have a problem returning an ADO resultset from SQL Server 7. If the out of memory occurs (as reported by the profiler), no resultset is returned. The problem is, it is intermittent! It doesn't happen regularly? What's wrong with sql server?"

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-10-10 : 12:51:39
SQL Profiler is a client-side utility; I don't have personal experience with an out-of-memory condition in Profiler, but it likely is referring to a client error, not SQL Server. You can verify this by checking the SQL Server error log.

Jonathan
{0}
Go to Top of Page
   

- Advertisement -