Comments
Sort by recent activity
Same problem here. A couple fixes would be nice. / comments
Same problem here. A couple fixes would be nice.
AH! Dammit, yeah, somehow I wound up with that feature reenabled on SSMSTP. I've disabled it and that seems to fix it. /facepalm. Sorry, all. And thanks for that, Aaron. Between SSMSTP, SSMSBoost, SQLPrompt.... / comments
AH! Dammit, yeah, somehow I wound up with that feature reenabled on SSMSTP. I've disabled it and that seems to fix it. /facepalm. Sorry, all. And thanks for that, Aaron. Between SSMSTP, SSMSB...
Wow, that was quick! Thanks! / comments
Wow, that was quick! Thanks!
Seems like it's a server issue. http://stackoverflow.com/questions/7525 ... -hresult-0
or possibly https://support.microsoft.com/en-us/kb/2003681/en-us
Looks like I need to restart the SQL Service, but I also read: "The problem is caused by updating the .NET Framework (to say, Service Pack 2) after SQL Server is installed. Repairing the .NET Framework restores the functionality."
FYI. / comments
Seems like it's a server issue.http://stackoverflow.com/questions/7525 ... -hresult-0
or possiblyhttps://support.microsoft.com/en-us/kb/2003681/en-us
Looks like I need to restart the SQL Service, b...
Michelle, thanks. However, I'd like to request it be added. The code already exists in order to pull out Merge replication - can it be extended to exclude Transactional as well? I don't know about most sites that use replication, but we use a pretty bog-standard one-to-many transactional setup. While I'm glad it can filter Merge, I'd really like for it to support Transactional.
Please add it to whatever request list y'all have.
Thanks,
Michael / comments
Michelle, thanks. However, I'd like to request it be added. The code already exists in order to pull out Merge replication - can it be extended to exclude Transactional as well? I don't know abo...
MANY thanks! / comments
MANY thanks!
Ben, I'm not using foreign keys for them. I did just try using "data types", but instead of 1 not-useful join, it gives me 30 or 40 not-useful joins along with the 1 useful join. / comments
Ben, I'm not using foreign keys for them. I did just try using "data types", but instead of 1 not-useful join, it gives me 30 or 40 not-useful joins along with the 1 useful join.
Already tried the KB mentioned (http://www.red-gate.com/support/kb/KB200702000008.htm), that didn't work. All the steps succeeded, but it's still not coming up in SSMS (QA working fine, surprisingly enough).
Any other ideas? / comments
Already tried the KB mentioned (http://www.red-gate.com/support/kb/KB200702000008.htm), that didn't work. All the steps succeeded, but it's still not coming up in SSMS (QA working fine, surprising...
Sounds like I miscommunicated - my main concern was getting back the work I hadn't saved. I wound up killing it and losing the work. QA does work (it was just that running instance that was borked), and I took this opportunity to upgrade my desktop tools to SP4. Maybe that will help. / comments
Sounds like I miscommunicated - my main concern was getting back the work I hadn't saved. I wound up killing it and losing the work. QA does work (it was just that running instance that was borke...
I take it you have tried uninstalling it? SQL Prompt for Query Analyzer is slightly different than for Management Studio in that it doesn't hook into Query Analyzer as a plugin, it runs a process that communicates with query analyzer. If the SQL Prompt 3 icon is not in the system tray or it is not running, then it should have no effect on Query Analyzer.
Would that were the case. However, once QA is borked, even uninstalling SQL Prompt doesn't return it to a usable state. Wound up learning a lesson.... save before using SQL Prompt. Sorry, guys - still a great idea with promising results but mediocre implementation. The annoying part is that when it works, it's awesome and hard to live without- then you run into things like this that make you curse its existence. It's worse than a clock that's stopped - this clock is right most of the time, then stops when you need it most.
</vent> / comments
I take it you have tried uninstalling it? SQL Prompt for Query Analyzer is slightly different than for Management Studio in that it doesn't hook into Query Analyzer as a plugin, it runs a proces...