Activity overview
Latest activity by NormL
This is a feature I'm totally wanting as well.
It would be a key reason for me using command prompt more. / comments
This is a feature I'm totally wanting as well.
It would be a key reason for me using command prompt more.
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. / comments
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...
Feature Request - Command Logging
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!
I'd love to be able to define what the default parameters are.
An option like the one for custom aliases would be excellent...
Ie @AccountId = 2 @%Year = 2010 (for any parameter like '%year')
Defining output parameters would be helpful too.
Norm / comments
I'd love to be able to define what the default parameters are.
An option like the one for custom aliases would be excellent...
Ie@AccountId = 2@%Year = 2010 (for any parameter like '%year')
Definin...
case sensitive column names
Expanding the * on the following query gives:
SELECT
cc.Id ,
Sequence ,
cp.Id ,
sequence
FROM Central.Table1 cc
JOIN Central.Table2 cp ON cc.Id = cp.Id
Which returns:
Ambiguous column name 'Sequenc...