Red Gate forums :: View topic - Feature Request - Command Logging
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5 EAP
SQL Prompt 5 EAP forum

Feature Request - Command Logging

Search in SQL Prompt 5 EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
NormL



Joined: 09 Apr 2010
Posts: 5

PostPosted: Thu Sep 02, 2010 3:51 pm    Post subject: Feature Request - Command Logging Reply with quote

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!
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Thu Sep 02, 2010 6:11 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
NormL



Joined: 09 Apr 2010
Posts: 5

PostPosted: Mon Sep 13, 2010 4:04 pm    Post subject: log request Reply with quote

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.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Mon Sep 13, 2010 4:52 pm    Post subject: Reply with quote

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

David
Back to top
View user's profile Send private message Send e-mail
williamd



Joined: 04 Jun 2009
Posts: 24

PostPosted: Thu Sep 16, 2010 9:48 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group