Posts
Sort by recent activity
No results for system databases
Trying to use SQL Search against system databases is not giving me the right results. Now I'm wondering is this by design?
Search term : backup
All object types
database : msdb
Only returns jobs an...
Exact match confusion with object names and square brackets
Against a copy of AdventureWorks2008R2, search for
[EMP_cte].OrganizationNode
with 'Exact match' unticked : this returns 2 results uspGetEmployeeManagers and uspGetManagerEmployees, and highlights ...
Restoring tabs based on SSMS version
I had 2 instances of SSMS open, one was 2008R2 the other 2012.
Each had 4 different tabs open.
I closed both of the SSMS down, and then restarted, 2008R2 first then 2012.
All 8 tabs reopened in the...
Refresh suggestions is limited to current connection
SQL prompt does support cross database queries, but if you refresh suggestions, it doesn't refresh the suggestions of the remote database, just the one you are currently connected to.
So for exampl...
Offer table/col name suggestions based on partial strings
I know this has probably been mentioned before, but I couldn't find it in the forums.
I'm working with a database where the column names are prefixed with 2 letters, an underscore, 2 more letters s...
OLR and Extended properties
Am I right in thinking that Object Level Recovery, does not include extended properties on columns, tables etc.
White graph on white background?
On Analysis page I often view some metrics by all databases to see a server-wide view, for example Log Space Used, to see if any of my pre-sized log files are nearing growth.
The graph automaticall...
SQL Server Memory Used graph on Global Overview
On the Global Overview screen, there is a small graph showing the memory used for each SQL instance.
Clicking the graph has no effect, and the link seems to point to "mySQLMonitorServer:8080\#"
In ...
Monitoring error - too sensitive?
I know I'm partly to blame for this....http://www.red-gate.com/MessageBoard/viewtopic.php?t=12538
But I seem to getting either lots of false positives, or the alert is too sensitive. There seems t...
Bug: invalid/deleted instances break Global Overview
I added a new (windows) server that has 3 named SQL instances on it.
I foolishly allowed it to assume that there was a local instance, and it tried to connect resulting in an error. I happily remo...