How to activate the T-Sql debugger to used from VB 6.0

Posted on 2002-04-05
Last Modified: 2008-03-10
Dear Friends,
   I am using SQL as back end and VB as frontend. I have written a stored proc and I need to debug it.I tried to use the Sql debugger but ot vain. I got the message to install some dll and try. I am using win 2k and Sql 7.
Anybody can contribute?
Question by:bhatul
  • 2

Expert Comment

ID: 6921599
Do you have query analyzer?  

Author Comment

ID: 6923579
I do have querry Analyser but the problem is parameters are
build at run time. Okay still those parameters can be extracted from VB. Then again how can I step throgh the Procedure. If it is possible through querry analyser please let me know. Thanks

Expert Comment

ID: 6923784
There is no way that you step through it one step at a time like in Visual Basic.  When I am debugging the procedures I copy the stored procedure into my query analyzer and then I just execute it section be section with some extra select and print statements inside to return results along the way.  It would be neat to have a debugger like that,  I am sure it will come.

Accepted Solution

ajay_karol earned 100 total points
ID: 6927353
Follow the following steps:

1. Check your DCOM settings using DCOMCNFG

Following setting should be in place

 Application Tab
      Identity Tab
         The interactive user

 Default Security Tab
    Default Access Permissions
        Edit Default Button
           Everyone (or domain\account and System)

2. Missing or unregistered DLLs


Make sure following file is present and registered:
c:\program files\microsoft sql server\mssql\80\tools\binn, then register it:
regsvr32 sdiclnt.dll

Make sure following files are present and register them as shown:

c:\program files\common files\microsoft shared\SQL Debugging:

then, register the files:

regsvr32 sqldbg.dll
sqldbreg /RegServer


Make sure c:\program files\common files\microsoft shared\SQL Debugging\sqldbg.dll is there and registered

Copy file mssdi98.dll from \x86\other\sdi to where sqlservr.exe resides (e.g. c:\program files\microsoft sql server\mssql\binn)

After that restart the SQL Server Service.


Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Powershell v3 - SQLCMD 3 27
fault SQL backup files that wont restore - how common 3 26
SQL Quer 4 22
sql 2016 data tools breakdown.. 1 15
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question