Posts
Sort by recent activity
Long Running Query - ID's wrong Process but right SQL
The query in question runs as User sa and is a SQLAgent Job - it has nothing at all to do with what SQL Response identifies as "Microsoft Content Management Server". The same query is correctly pu...
Blocked Process - More info when it's a Job, please?
Yes, I could elevate the monitoring, but the simple fact that the "Blocker" is a SQLAgent Job whose SQL is listed begs the question, "What's the name of the Job, please?"
Could you pull that into t...
Recommendations - need fixes
Comprehensive as the "Recommendations" are, in small shops they become more of an irritation because there's no "Fix It/Recommended Fix Action" provision. In "no-DBA" shops it's simply saying "it'...
Password Encryption Enhancement Request
Didn't find a post elsewhere on the forum, do excuse if already requested...
The backup command uses
PASSWORD = ''<ENCRYPTEDPASSWORD>owM5dGLGbGE=</ENCRYPTEDPASSWORD>''
but the RESTORE ...
Unhandled Exception
Removed all scripts from upper pane.
Delete All from server results pane.
Clicked the X button to close it down.
The virtual server it was last connected to had been brought down prior to my action...
Changed Table Variable definition not re-scanned (3.6.0.109)
If I declare a table-variable and then write some code that consumes it, SQL Prompt picks up the TV and auto-completes OK. If I then make significant changes to the structure of the TV, how do I p...
Stunned! "No Candidates"
Cache refreshed.
New Query Window.
Typed:
SELECT * FROM dbo.Country c WHERE c.
and "No Candidates" either offered or Ctrl+Space requested.
How can such a simple statement be so simply ignored?
Ver...
DC6 RC1 - A few niggles, a bug and some bravos
1. The behavior appears to have reverted back to highlighting and positioning the list at the selected table in the list of "identical rows only" after syncronization (expanding the pane that was c...
Large scripts still slow
3.5 Production version is still slow handling longish SPs. The one I wanted to change just three consecutive lines within is only 700 lines in total, with 600 between the AS and GO. The cursor ta...
Cache Refresh (Auto) takes forever and hangs VS
Upgraded to 3.5 after uninstall of 3.5 RC and reboot.
Cache manager window is still open after about an hour of work. It sometimes shows the connection and progress, other times just the logo, tit...