Posts
Sort by recent activity
Job NAME, please, for Long-running query Alert
The detailed Alert only shows the (IMO, useless)
SQLAgent - TSQL JobStep (Job 0x7E66EF0586D3664D8C19F98745BE05C8 : Step 1)
line.
Having snagged the Step ID, please go one step further and ...
SQL Server Instance Offline - Really? (v2.1)
I've received three Alerts over the past 48 hours telling me that my cluster instance is OFFLINE.
The first time it happened my colleague was thrown out of SSMS on the cluster itself.
The 2nd time,...
After upgrade to 2.1 - MOLASSES
Just upgraded from 2.0 to 2.1.
Pulling up an Alert now takes 15 seconds and over 50% of the CPU for all that time.
To clear an Alert takes 10 seconds.
IIS7 on 64-bit Windows Server 2008 SP2. Dual ...
Relocating Web Service to DMZ - considerations?
SQL Monitor successfully up and running with IIS7 and the Base Monitor on the same SQL Box.
With the need to expose the website we need to migrate to the DMZ, to IIS7 again.
NOT being IIS-versant, ...
8.1.0.4 REFUSES to compare based on my CUSTOM KEY settings
I repeatedly set custom keys for comparison of the SAME table across the SAME database across 2 instances, both SS2005. I set the custom comparison key and EVERY TIME I run "Compare Now" DC tells ...
WITH (NO)CHECK .. NOT FOR REPLICATION Treated the SAME!
I want to create my FK constraints WITH CHECK and include the NOT FOR REPLICATION phrase.
Whatever I try, SSMS insists on WITH NOCHECK and an ALTER-CHECK immediately following it whenever I script ...
Integrate into existing 3+ year changeset history
I have a Subversion source control repository and Tortoise SVN Client setup that dates back at least 5000 changesets and has all database artifacts within it - 8 databases.
I have NO desire to lose...
When will COPY_ONLY be supported from the UI, Please
COPY_ONLY is a keyword that's been around since SS2005, so when will RG support it in the UI - I see it didn't make it into 6.4...
I have an 80+ gig DB that I need to COPY_ONLY from Prod to QA and...
Exception: capacity was less than the current size
Build: 1.3.0.58Client: Windows 7 UltimateServer: 2003 32-bitDB: 2008 SP1What: Viewed a deadlock. Clicked the next exception, which is a "Long running query" and the exception below occurs.When: Eve...
Enhancement Request: Edit user-added Extended Properties
Just went to update an Extended Property I use to declare the "Table Alias", which is used to standardize query aliases and apply naming conventions to indexes, constraints, et al. Couldn't update...