Feature Request - Command Logging

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Feature Request - Command Logging

Postby NormL » Thu Sep 02, 2010 3:51 pm

Would love a feature to log all commands run.

Logs could be saved to files like c:\\...\\LogDirectory\\[ServerName]\\[DatabaseName]\\[YYYY-MM-DD].log

Entries would be timestamped.

Thanks!
NormL
 
Posts: 5
Joined: Fri Apr 09, 2010 8:55 pm

Postby David Atkinson » Thu Sep 02, 2010 6:11 pm

This is fairly frequently requested. Many have asked for the ability to recall a previously run query to a query window.

Would you want all queries run on all databases to be logged? Is this for a given instance of SSMS, or do you expect it to know what has been run against a server from a different machine or a different tool?

A typical example of where this feature would have been useful to you in the past will be helpful to us.

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

log request

Postby NormL » Mon Sep 13, 2010 4:04 pm

All queries for all databases from given SSMS instance is what I'm after.

Partly to be able to reuse queries that we though were one time queries, but turn out to be handy again. Partly to log the work done. And partly to have a history of manual queries.
NormL
 
Posts: 5
Joined: Fri Apr 09, 2010 8:55 pm

Postby David Atkinson » Mon Sep 13, 2010 4:52 pm

Is it important to log details about which connection the query was run against?

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby williamd » Thu Sep 16, 2010 9:48 am

I think that the information about the connection is important. If you check the SSMS Tools Pack from Mladen Prajdic, he has this too. The only thing that is then missing, is to restore the command session - SSMS Tools Pack cannot do that, it just stores the information.
Regards

William
williamd
 
Posts: 24
Joined: Thu Jun 04, 2009 4:04 pm


Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests