Posts
Sort by recent activity
'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...
"CommandText not init"/"Cancelling Previous Task" forever?
Howdy. I'm getting the following, trying to compare a 2012 & 2014 box.
After I give the server names, if I click "compare" I get: "ExecuteReader: CommandText property has not been initialized"
How...
Replication - skipping sp_MS[del|upd|ins] triggers in 6.2?
For some reason the "Ignore replication triggers" doesn't seem to work. Even though I have it selected, I still get a list of all the sp_MS triggers. Is there some sort of trick to this? Either ...
Request: tablea.tableb_id = tableb.id
We frequently use ID as the key, and reference it in other tables by tablename.id. So store.id would be the referenced in another table as store_id. However, the autojoiner only comes up with tab...
Microsoft .Net crashed due to SQLPrompt - and I must reboot?
This sucks - I just had SQLPrompt crash SSMS - and it looks like I'll have to reboot to get rid of the error. (I've clicked it at least 100 times, which means I can't see the results of the long-r...