none
USE statement and SQL Debugger

    Pertanyaan

  • Hi,

    Does anyone knows how to turn on/off the USE statement from SSMS?

    And where to find SQL Debugger for SQL Server 2008?

    Thanks!

    17 April 2012 2:10

Jawaban

Semua Balasan

  • What exactly do you mean? In the script options?

    You can initiate debugging by pressing Debug button.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    17 April 2012 2:15
    Moderator
  • Go into the Options menu and scroll down to SQL Server Object Explorer - scripting.  There is a selection there to disable scripting the  use database

    Chuck

    • Ditandai sebagai Jawaban oleh Beck's 17 April 2012 3:31
    17 April 2012 2:40
  • Go into the Options menu and scroll down to SQL Server Object Explorer - scripting.  There is a selection there to disable scripting the  use database

    Chuck

    This is perfect! Thanks Chuck!
    17 April 2012 3:31
  • What exactly do you mean? In the script options?

    You can initiate debugging by pressing Debug button.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    It has said that SQL Server 2008 has a SQL debugger. I just have to turn it on in my computer? 

    17 April 2012 3:35
  • What exactly do you mean? In the script options?

    You can initiate debugging by pressing Debug button.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    It has said that SQL Server 2008 has a SQL debugger. I just have to turn it on in my computer? 

    The debug button that Naomi is refering to is the green arrow in the toolbar of ssms.  Some reading here on it:

    http://blogs.msdn.com/b/billramo/archive/2009/04/11/transact-sql-debugger-for-sql-server-2008-part-1.aspx


    Chuck

    • Ditandai sebagai Jawaban oleh Beck's 17 April 2012 9:37
    17 April 2012 3:49
  • Yes, thanks Chuck for the link, it was helpful.

    I am able to use my debugger now.

    17 April 2012 9:37