Posts
Sort by recent activity
Can you stop Code Analysis from preventing the popup so I can get the script for an item?!
Okay, I'll ask here before I simply turn it off, since I see the overall value in the Code analysis feature. But I'm always using SQLPrompt's ability to show the entire script for a table/SP, which...
Using SSMS w/RUNAS, SQLPrompt "Dependencies" tab "says "please install SQL Dependency Tracker"
Howdy. I'd not used it this way before, but today I decided to click on the "Dependencies" tab within SQL Prompt. To my surprise it says "To see dependencies for this object, please install SQL D...
convert old-style SQL Prompt snippets (the XML version) to the new JSON format?
I don't seem to find anything. I have a couple dozen snippets that obviously won't work in the new style, and I don't see a way to migrate them. Help?!
What kind of support is available for MySQL Compare?
I haven't seen any new versions since I first bought it a year ago, I still have an outstanding bug request and it appears to be discontinued. Can someone confirm? Thanks.
'Medium: Non-standard Filegroups' even if they exist?
Trying to figure this out - coworker said "oh, you'll get used to it". Pretty much all of our databases have named filegroups - PRIMARY is meant to be system objects, we have named filegroups for ...
comparing mytable and mytable_new in the same database WITH COMMAND LINE (CLI)?
We are trying to compare the schema on a before/after tables. Right now we have mytable_a and mytable_a_new,, but will be "flipping" the table names so that mytable_a_new becomes mytable_a, and th...
[Bug] when using IN() and hit comma, prompts to add field
I want to write an IN clause like this:
select * from blah where id in (11235,345632,3463453,663634)
When I write the code, I set up the in, paste in the list, then add commas. So it looks like:s...
[BUG] Fields not prioritized when hitting ENTER (vs TAB)
Kind of a weird one on 7.2.4.291.
I have a field titled EXTRACT_DETAIL. When I type
SELECT * FROM MYTABLE WHERE WHERE ext
, the SQLPrompt popup of fields comes up, with EXTRACT_DETAIL at the top....
Getting .Net SqlClient Data Provider calls from redgate tool
Howdy. Would like to request that y'all change one of the SQL Source Control/SQL Compare connection strings so that the application name shows up properly.
I ran a trace, and during it had a cowor...
Failed to initialize the CLR?
I'm getting the following messages trying to run comparisons on some (though not all) servers. Additionally, all have "clr enabled" = 0 in sp_config.
X Registering data sources
servername.database...