Activity overview
Latest activity by Robert C
Recommendation: When deploying PST Agents, use a CNAME
When you deploy the PST Agents to your computers, you will need to supply the hostname of the PST Central Service.
We recommend that you create a DNS CNAME (or "Alias") record and use this rather t...
PST Importer Early Access Program Released
We're pleased to announce the release of our Early Access Program for the new PST Importer.
The PST Importer allows you to:
- Search your network for PST files
- Report on all files discovered, inc...
Hi,
It seems like there's issues selecting in the object explorer in non-English versions of SSMS (SDI-40 for our reference); I've logged the SSAS issue as well (SDI-50), but don't have an SSAS instance to hand, so we'll need to investigate that one further.
Thanks for the comments - we'll let you know when we make some progress on those issues.
Many thanks,
Rob / comments
Hi,
It seems like there's issues selecting in the object explorer in non-English versions of SSMS (SDI-40 for our reference); I've logged the SSAS issue as well (SDI-50), but don't have an SSAS ins...
Interesting - I'll have to investigate that one further, but it looks like the encrypted sprocs could be the guilty party. The intended behaviour is to ignore them (though the request to decrypt them is noted!), but possibly something's going wrong there...
Thanks,
Rob / comments
Interesting - I'll have to investigate that one further, but it looks like the encrypted sprocs could be the guilty party. The intended behaviour is to ignore them (though the request to decrypt th...
Thanks Dave - received.
There's nothing reported in the logs that would suggest a problem, and it shouldn't be Win7 either (one of the developer's machines was running Win7 x64 Enterprise as well).
So just to confirm, if you do this:
- Select a single DB in the Object Explorer
- Open SQL Search. That should select that DB in the combo box
- Type a couple of characters such that it begins searching
- Wait until you get search results
- Switch to a different DB
- At this point it might start indexing the other DB, but should then give you search results
- Switch back to the first DB
- Here it should almost instantly return results.
If it doesn't, does the progress bar say "searching" or "indexing"?
Out of interest, if you've got multiple copies of SSMS open at once, could you try reproducing it with just the one copy running?
Thanks,
Rob / comments
Thanks Dave - received.
There's nothing reported in the logs that would suggest a problem, and it shouldn't be Win7 either (one of the developer's machines was running Win7 x64 Enterprise as well)....
Hi,
This certainly shouldn't happen, unless you change databases while it's still indexing for the first time (incomplete indexes are discarded if they're cancelled part way through).
If you look in C:\Docs & Settings\<username>\Local Settings\Application Data\Red Gate\SQL Search, there should be some log files - would it be possible to e-mail them to me at robert.chipperfield at red-gate.com, and I'll see if I can see what's going on?
Thanks,
Rob / comments
Hi,
This certainly shouldn't happen, unless you change databases while it's still indexing for the first time (incomplete indexes are discarded if they're cancelled part way through).
If you look i...
Sorry about that :-(
Yes, it should clearly be sorted - it's logged (SDI-43) and fixed, so should be correct in the next release. / comments
Sorry about that :-(
Yes, it should clearly be sorted - it's logged (SDI-43) and fixed, so should be correct in the next release.
Good stuff - those characters at the front are almost certainly unicode byte order marks, in case you're interested! / comments
Good stuff - those characters at the front are almost certainly unicode byte order marks, in case you're interested!
Hi,
brigzy wrote:
Here is my command line:
"C:\Program Files\Red Gate\SQL Compare 8\sqlcompare.exe" /Server1:Partner-Dev /Database1:rdb_partner_chall /Server2:Partner-Dev /db2:partner_chall
/scriptfile:"C:\test.sql" /force
I think you have a line break between "partnet_chall" and "/scriptfile"; if you remove this and enter the whole command as a single line, it should work.
Cheers,
Rob / comments
Hi,
brigzy wrote:
Here is my command line:
"C:\Program Files\Red Gate\SQL Compare 8\sqlcompare.exe" /Server1:Partner-Dev /Database1:rdb_partner_chall /Server2:Partner-Dev /db2:partner_chall
/scrip...
That's a fair point!
Unfortunately we're not going to be able to incorporate it into version 1.0, as we're in the final stages of testing now, but I've added an enhancement request (for reference - ESA-2278) so we'll review it for the next version.
Many thanks,
Robert / comments
That's a fair point!
Unfortunately we're not going to be able to incorporate it into version 1.0, as we're in the final stages of testing now, but I've added an enhancement request (for reference -...