Posts
Sort by recent activity
Search for a string?
How do I search for a string set? I want to find "[StatYear] - 1" but when I type this in or no square brackets or single quotes I get all results for StatYear and also results for 1 and also resu...
Azure Compare, Select Into
SQL DC 11.3.0.7
I'm getting an error when trying to deploy a data compare my SQL 2012 to my Azure db:
SELECT INTO not supported in this version of SQL Server. With no hits here in the forums, it m...
DLM Dashboard on FF 39.0?
When I logged in this morning, my DLM Dashboard page says 'DLM Dashboard doesn’t support this browser version. Try using the most recent version of Chrome, Firefox, or Internet Explorer.' I'm on...
Escape Characters
How do I search for the Percent Symbol? %
It's a wildcard, but I want to show all my views that use wildcards, but I can't find anything in the documentation about how to make searches literal.
I ...
Can't turn off alerts for Auto Restore Jobs
I run a job at 3am the restores all 27 of my dbs with drop on success. Weird things show up in SQL Monitor:
1. Page verification set to off alerts on 8 of the 27. Why not all 27? Some are Simple...
Checkbox for ALL
I know some of your other products have this, but: Where is the select all check box for Sync'ing all of the tables. I have several tables in my db that have update triggers, so I have to do each ...
Filtering returns no results inside db
When I filter my alerts on cleared alerts and long running queries I get 49 results. I know some of them are from certain db's and others are SQL Agent jobs. When I drill into an SQL Agent job al...
Moving the base monitor db
I have only one db server and another IIS server, so I have the Monitor db on the primary server with the server and databases being monitored, but connected to the IIS web server.
Now, I've instal...
Typo in Deadlock description
In my Alerat:Deadlock trace flag disabled, under description is the following text:
Deadlock trace flag
Raised when the deadlock trace flag is not set on your SQL Server instance.
What is the deadl...
Formating not correct when using OVER()
I just ran a cntrl K + Y and this is what I got
SELECT tst.TransId
,tst.TransType
,tst.Invoice
,tst.OrgId
,tst.IndId
,tst.PUB
,tst.Media
,tst.TransDate
,tst.Amount
,tst.GST
,tst.Reconciled
,tst.Vo...