Posts
Sort by recent activity
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...
Move Repository Directory
I installed the Alert Repository to my production data directory. I now want it moved to another directory on the same server. How do I do this? Will I lose all my Alert history?
Completely Non-functional
SQL Search crashes SSMS.
I get the error reporting message as soon as I enter the Search page, and after I type 2 characters it error reports again, then crashes SSMS
SSPI HAndshake failed - Windows Applicaion log error
Windows XP SP2
SQL Server 2005 9.00.3042
SQL Prompt 3.9.0.43
The Application Log on the Windows 2003 SQL Server box is getting the following error:
SSPI handshake failed with error code 0x8009030c ...