|
|
Posted by Erland Sommarskog on 05/10/06 00:27
(mednyk@hotmail.com) writes:
> T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures
> And there is no other procedure with the same name owned by dbo or any
> other users.
> There is no error messages also, it just completes procedure and
> returns result
> server:
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build
> 2195: Service Pack 4) and I don't know how do determine Client's
> version.
You can determine the client version from Help->About in Query Analyzer.
I believe that SP2 or earlier of Query Analyzer does not work with
SQL Server SP3. SP3 is 8.00.760. 8.00.818 is a hotfix to SP3 with a
security fix. 818 should work with 760 on the client.
Unless you have the server on the local machine, it is difficult to get
the debugger to work. There are so many things that have to be aligned.
Personally I have given up.
If you are running Windows XP SP2 on the client, you should upgrade to
SQL 2000 SP4, particularly if you are using the XP firewall. But it
does not sound like that - in that case you get an error message.
I believe that the problem when single-step does not work is that
SQL Server does not have privilege to write to your machine from
some port. This is usually due to that SQL Server runs under local
system, or it runs under a domain account with insuffcient privileges.
These days, DBAs perfer to run SQL Server under an account with a
small set or permissions to decrease the surface area in case of an
intrusion.
In Books Online, you can look under Troubleshooting->SQL Server Tools
Troubleshooting -> Troubleshooting the Transact-SQL Debugger and see if
you find any useful tips.
I've found that debuggin with PRINT and SELECT takes me a long way.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|