Forum Replies Created

Viewing 6 posts - 16 through 21 (of 21 total)

  • RE: ODBC Problems

    I haven't got an answer, except to say you're not going mad - I have exactly the same problem on my PC. I have given up using ODBC Data Source...

  • RE: SQL commands captured via ODBC connection?

    IMHO, SQL Server is short of analysis tools - Oracle, for example, comes with a tool named tkprof which does pretty much what you want.

    For SQL Server, SQL Profiler is...

  • RE: Deadlock issue

    OK.

    What version of SQL server ?

    What indexes do you have on the table ?

    What is the execution plan (Query Analyzer will show you that) ?

  • RE: Question about how new SPIDs spawn

    I don't know about spawning SPIDs via sp_OAcreate. But the "Host" and "Application" columns in the process info view (which are simply read from the table master.dbo.sysprocesses) are filled in...

  • RE: Deadlocks with read

    In reply to Carl B: I don't think I've seen this behaviour in any documentation. I discovered it the hard way - first from the logging info given by Trace...

  • RE: Deadlocks with read

    It is possible to get a deadlock just with a SELECT, even at the default READ COMMITTED isolation level. IMHO this is a design error in SQL Server. SELECTs never...

Viewing 6 posts - 16 through 21 (of 21 total)