Posts
Sort by recent activity
Change PK cols and Non-CL Index should DROP NCL First?
I could be wrong, but I thought it was more efficient when changing the PK and dropping a non-clustered Index on the same table to drop the non-clustered index first, then drop the PK.
In my case, ...
SSMS2012 - Crash moving SSC Tab - v3.5.4.332
Several things, the worst of which is that SSC crashed SSMS and when it came back up I had to reconfigure the UI elements.
1. If I have TWO vertical tab groups open, right-clicking a database and c...
Still "Unable to detect Base Monitor"
Even following the "resolution" in an earlier 4.0 Base Monitor problem-post, using the App Pool login, I still get the error, "The credentials supplied to the package were not recognized".
The "Tes...
Question: OnTime integration - any/none/possible?
We're currently using TRAC and SVN with SSC and have the TortoiseSVN client, too (needed for SSRS and SSIS commits).
Upon Commit in SSC we add, for example, [ticket:1234] as a comment and SVN logs ...
ERASEFILES on remote server fails for just 1 DB
Server Version 7.6.0.29 but has been having issues for many months on prior 7.x versions.
I have 8 databases including the system and 2 SSRS DBs.
Two of them are copied over the network to the exac...
Please STOP auto-refresh!
I know I've asked for this before, AND added a request to Uservoice, but after six YEARS of constantly being annoyed and LOSING TIME while reviewing the Activity History BECAUSE OF THE DARNED AUTO-...
Cannot restore to local Windows8 - error 15404
SQL error 15404: Could not obtain information about Windows NT group/user 'MyCompany\me', error code 0x5.
I'm the only User who set up this machine and is successfully logged into the domain and is...
3.4.1.4 Installer error 0x800b0110
Multiple attempts to download using the upgrade are available link, and even used the returning customer - need the installer.
BOTH failed to verify the installer. Can continue nearly all the way ...
5.3.8.2 downloads but no installer appears on Windows-8
I'm used to having the download portion lock SSMS while it completes, then the installer fires up and requires SSMS be closed out.
I see the download progressing, disappearing, then... NOTHING!
Jus...
5.3.6.28: No prompts for simple script
Having added a list of DECLAREd variables to my 17-line script, shown below, I expect SQL Prompt to prompt me with a variable if I double-click the literal 116 in the exec and type @ variables. Th...