Posts
Sort by recent activity
How to Deactivate if SQL Server is no more
We had to "destroy" a SQL Server to poach its SAN disks but didn't deactivate SQL Backup first, so we're down 1 activation.
Is there a script you could provide that will deactivate the instance, pl...
3.1.0.125: Monitoring Stopped 1 sec - no auto restart
Machine authentication failed at: 1 Jul 2012 12:35:25 AM
Machine authentication successful at: 1 Jul 2012 12:35:26 AM
No performance data available for this host machine or SQL Server instance i...
7.1 Multiple Threads question
Having run 7.1 for the first time and seen the elapsed time reduced for a Full backup of a 300GB database using compression level 4, 7 threads and Verify, I noticed a Processor Utilization Alert fr...
7.1 Cluster Failover provoked on Passive Node upgrade
I just upgraded the Active Node, then the Passive Node, just as I usually do.
On the Active Node, everything went per usual:
Update the GUI
Navigate to the 32-bit Program Files and run the Service...
3.1.0.125: CLOCK SKEW Fixed over 35 minutes - still "Active"
w32tm /config /update was issued on the problem node and on the Base Monitor server but the HIGH Alert is still "Active".
Why is this, please?
DEFECT: 3.0.11.3531 - Table Rename not recognized
Having just run "Smart Rename" on two tables in the same database, refreshed the Tables node in SSMS and hit Ctrl+Shift+D and seen SQL Prompt refresh my suggestions list, I was appalled to see no c...
DEFECT: 5.3.2 - Script as ALTER shows as modified
When we right-click in Object Explorer and either "Modify" or "Script as ALTER", SSMS gives us the script and there's no "*" to show a modified script exists in the window.
However, hovering over, ...
SOLVED: 5.3.2 - Format SQL twice in right-click menu
After upgrade from 5.2.0.3 I find that the "Format SQL" and "Script Object as ALTER" right-click options are duplicated. The topmost pair are available, the lower pair, below a divider, are greyed...
DEFECT: 1.1.6.1 - Hits clear when changing to All Databases
In my case, I searched for usage of a UDF in a named database. I get three hits. Change to "All Databases" and the hits list is cleared.
Poke it 1: "Force Reindex" - no hits.
Poke it 2: "Refresh"...
Defect: 5.3.2 no prompting in RAISERROR()
For any attempt to use Intellisense within a RAISERROR() there is no prompting - list says "No suggestions". This is consistent in any and every SP I edit.
Sample:
RAISERROR('Not at 12hrs UTC ...