Posts
Sort by recent activity
Results from SQL Data Compare of msdb
Hello experts,
I have tried SQL Data Compare 12 with the msdb database on two different servers and get blank results. I mean totally blank - not a list saying all data is identical.
Does anyone kn...
SQL Prompt 7.2.2.273 update took away Source Control?
Hello experts,
A few days ago I decided to update my SQL Prompt to version 7.2.2.273. Now it seems when I open SQL Server Management Studio, the source control icons for one of my database servers ...
SQL Source Control icons
Hello experts,
What do the SQL Source Control 3 icons mean? For example, one database that I linked to source control shows a green cylinder with a small gray sphere near the bottom, but another da...
SQL Prompt 5 and INSERT statements
Hello experts,
When I format SQL for an INSERT statement, the columns in the INSERT clause are always formatted with a line break after each column. But I want them to match whichever format I choo...
Connection failed for (local)
Hello experts,
I want to know the possible causes of this scenario, and how it can be fixed.
1. I am running SQL Monitor 3.3.
2. We recently upgraded two servers from SQL 2008 R2 to SQL 2012.
3. On...
Relocate SQL Monitor 3.3 to a new server
Hello,
I'm running SQL Monitor 3.3 on my desktop computer but now a server has been made available for me. Does anyone know how I can switch the monitoring software and the corresponding license so...
Exporting SQL Monitor 2.3 alert data
Hello,
Is there any way to export data (Excel or CSV) from the list of uncleared alerts that show when one clicks Overview?
I have a list of Deadlock alerts and would like not to have to go through...
Lower-case all columns and tables in queries?
Hello,
Is there any option in SQL Prompt 5 to format SELECT and other queries so that the column and table names are all lowercase?
For example, an option that would turn this code:SELECT MyColumn,...
Data Statements - formatting with INSERT statement
Hi,
I want to format an INSERT SQL statement with a SELECT statement (not a VALUES statement) without having each column on a new line.
When I highlight the code and choose Format SQL, it puts mult...
What are Base Deployment Logs?
Hello all,
I have 800+ MB of files in my SQL Monitor 2 installation named
Base Deployment yyyymmdd.log (where yyyymmdd is the date pattern for the file naming)
Are these files necessary beyond a ce...