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 2005 Forums
 Transact-SQL (2005)
 SQL Profiler with SQL Express?

Author  Topic 

JohnJohn73
Yak Posting Veteran

57 Posts

Posted - 2007-10-16 : 16:57:08
Hi again.

I'm using SQL Express 2005 that ships with Visual Studio 2005. All of my coding and debugging (limited) happens in the VS2005 ide.

SOmeone mentioned using SQL Profiler or something, but I'm not sure I have that option.

For example, I would like to step into one of my update procedures, and follow the logic into the trigger, but I am not sure to do this, other than PRINTing everything.

Any ideas folks?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-16 : 17:01:06
SQL Profiler doesn't allow you to step into stored procedures. It allows you to see what is going on inside SQL Server though.

Stepping into code can be done in Visual Studio though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -