SQL Server 2005 T-SQL debugging alternatives

With no T-SQL debugger in SQL Server Management Studio you can use Visual Studio 2005's T-SQL debugger, but if you're not a fan of step-debugging, SQL Server 2005 expert Adam Machanic has detailed some alternatives.

I recently read your response to the Query Analyzer having been replaced by the new SQL Server Management Studio. As it does not include a T-SQL debugger, what do you recommend as an alternative?

Unfortunately, you are correct: SQL Server Management Studio does not include the T-SQL debugger that was present in SQL Server Query Analyzer. Microsoft's solution is that developers wishing to debug T-SQL should use Visual Studio 2005, which does include a T-SQL debugger.

Personally, I am not a fan of step-debugging T-SQL at all. I find it a cumbersome process. The lack of visibility...

Step 2 of 2:

into temporary tables and table variables makes it less-than-ideal for most debugging scenarios I've encountered. I discussed some alternatives in an article Debugging with Macros and Assertions, which I wrote for SQL Server Professional magazine.

This was last published in June 2006

Step 3: Consider using implicit transactions

Related Q&A; from Adam Machanic

Database Snapshots: Creating read-only copies of a database

Database Snapshots feature in SQL Server 2005 Enterprise Edition creates read-only files. For these separate databases, our site expert Adam Machanic...continue reading

Stored procedure concurrency problems in SQL Server 2005

Multiple readers can sometimes read the same row simultaneously causing a false result. SQL Server 2005 expert Adam Machanic suggests modifying the ...continue reading

Upgrading SQL Servers

Migrating to SQL Server 2005 from SQL Server 2000 is a hefty feat when compared to upgrading from 7.0 to SQL Server 2000. Site expert Adam Machanic ...continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Google's cloud-based platform aims machine learning, AI at enterprise

Google's enterprise cloud platform is starting to become a factor in business IT thanks to strong data preparation, machine ...

IBM cracks the code for speeding up its deep learning platform

Using more GPUs when training deep learning models doesn't always deliver faster results, but new software from IBM shows it can ...

AI washing muddies the artificial intelligence products market

Artificial intelligence products are the future and many tech vendors are AI washing to trick potential customers into thinking ...

SearchDataCenter

A close look at DCIM software and the broad vendor options

DCIM software addresses a diverse range of data center needs and functions. Learn about the vendors in the market and the ...

Public vs. private cloud cost comparison finds enterprise winners

Nearly half of enterprises do not save money with the public cloud, and say they have figured out how to beat public cloud costs ...

Emerging data center workloads drive new infrastructure demands

Big data, IoT and AI offer enterprises a number of new opportunities. But first, IT teams need to ensure their infrastructures ...

SearchDataManagement

HR metrics and analytics tools propel human resources into hyperdrive

For those of us who can remember, something called a personnel department was the go-to place to apply for a job, fill out...

Rising database security threats require attention -- and action

Data management teams are asking more questions about data security, Gartner analyst Merv Adrian says in a Q&A.; But new factors ...

Database protection methods expand to shield data from attackers

Database vendors have beefed up the security tools in their software -- and that's a good thing because attackers are ...

SearchAWS

Get in tune with the AWS Spot market to save money

Enterprises that want more flexibility with EC2 Instances can turn to AWS Spot Instances to save money without having to agree to...

Build better apps with these AWS hybrid cloud development tools

Hybrid cloud often is a goal for many enterprises, but getting there is a challenge. AWS has a host of hybrid cloud tools to ...

AWS updates beef up automation, integration for enterprise tasks

AWS seeks deeper enterprise engagement with new AWS security and monitoring that incorporates machine learning and a migration ...

SearchOracle

What the annual Oracle Database release cycle means for DBAs

As Oracle changes its database release cycle to yearly updates with new version numbers, Oracle users will get faster access to ...

Oracle Cloud apps updated as Oracle extends EBS support

While Oracle Cloud apps are getting a new update, the company says it isn't leaving its on-premises EBS customers behind.

Migrate an Oracle RAC database to new servers with zero downtime

Most organizations can't afford any downtime on their Oracle systems. Here's how to move RAC databases to new server nodes and ...

SearchContentManagement

IAM strategy: Usability vs. lockdown security

With content management user authentication, you need security. But how much is too much? Here are some best practices to seal ...

A personalization engine comparison: Acquia, Evergage, and Google

A personalization engine can help provide a better customer experience. Expert Geoff Bock helps break down the differences ...

Physical records management here to stay along with digital records

Some organizations, because of audience or regulatory reasons, are stuck with paper indefinitely. Learn how three organizations ...

SearchWindowsServer

PowerShell repository supplies a quick route to scripts

Don't have time to sift through thousands of PowerShell scripts to find one for a specific task? The PowerShell Gallery is ...

Azure DevTest Labs offers substitute for on-premises testing

Test environments in the data center can be restrictive and slow progress. Here's how to use Azure DevTest Labs to free up the ...

Expect service providers to ease Azure Stack deployment

Azure Stack will be ready in September. But given the product's complexity, early customers might think about working with a ...

Dig Deeper on SQL-Transact SQL (T-SQL)

Related Q&A; from Adam Machanic

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.