CODEWITHSUNDEEP
sql-serverlogging
Toby
Toby

Reputation: 8792

Is there a Console or Log view in SQL Server Enterprise Manager

Is there a console or log view which can be accessed within SQL Server Enterprise Manager that would show me the SQL statement which was ran as a result of changing something using the GUI?

Upvotes: 0

Views: 117

Answers (2)

Richard
Richard

Reputation: 109005

Many of the dialogues have a Script button (often top left of the dialog) which gives options to generate a script equivalent of pressing OK. Ie. select the script after choosing the options you want and before pressing OK (and often you'll want to press Cancel instead).

This doesn't provide for determining the SQL retrospectively.

Upvotes: 0

Chris Diver
Chris Diver

Reputation: 19812

If you just want to see how SSMS is doing something you can use SQL Profiler and monitor the commands from sent to the database.

Upvotes: 3

Related Questions