Activity overview
Latest activity by ofrede
Okay, problem solved! There was something wrong with my license at Red-gate. So they gave me an extra license for the DLM Automation Script product. Problem solved ... / comments
Okay, problem solved! There was something wrong with my license at Red-gate. So they gave me an extra license for the DLM Automation Script product. Problem solved ...
Activate license on server
I have just bought the SQL Toolbelt in order to be able to execute SQL Data Compare via Command Line (CmdExec in SQL Agent Job).But I have a problem activating the license on the server!I have not ...
Keith_J, I recall that I had the problem on a database on a server, which was a copy of another database on the same server. Basically I had backed up a database on server and restored it with another name on the same server. Is that the same issue? Because if it is, it might give Red-gate a hint about what the problem is. I never got the problem solved - but the problem only exists on the one, copied/restored db. / comments
Keith_J,I recall that I had the problem on a database on a server, which was a copy of another database on the same server.Basically I had backed up a database on server and restored it with anothe...
Hi Eddie, You are absolutely right! I was of the impression that if I had the application installed on my PAS then it wasn't necessary to have it installed on my PSS. Thank you very much for the answer and the explanation. Case closed! / comments
Hi Eddie,You are absolutely right!I was of the impression that if I had the application installed on my PAS then it wasn't necessary to have it installed on my PSS.Thank you very much for the answe...
Time out from one but not the other server!
I have 3 servers:Development Server (DS)Production SQL Server (PSS)Production App Server (PAS)Problem:When I call SQL Data Comparer from PSS it fails with a "Timed out trying to connect" but when c...
Tab Color (Server) does not save
Hi,Running SSMS 18.6 and have just upgraded to SQL-Prompt to 10.4.1.16091. But for quite some while, I have noticed that when I select a Tab Color for my servers, they are not being saved. So when ...
Bug: Refresh suggestions does not include new columns.
When adding or removing a column to a table and pressing CTRL+SHIFT+D (Refresh Suggestions), Sql Prompt no longer updates correct.
If I write SELECT * FROM <myNewlyUpdatedTable> and press the TAB-k...
Lenka wrote:
I just installed SQL Management Studio 2016 and updated my SQL Prompt to 7.2.0.260. SQL Prompt works fine for the snippets and for the SQL built-in functions, but it no longer shows any of the objects in my database or their columns, in either 2012 or 2016.
Having the same problem. Sometimes it seems to restart MSSMS and then it works for another 15-20 minutes. Now and then the all suggestions (like ssf) are gone but right now it is "only" my database objects (table names, column names etc).
I even had a strange experience where pressing the ENTER key would paste my text from the clipboad into my script and pressing other keys also behaved oddly. A restart of MSSMS solved that.
Using MSSMS 2012 version 11.0.6020.0
and SQL Prompt 7.2.4.291 / comments
Lenka wrote:
I just installed SQL Management Studio 2016 and updated my SQL Prompt to 7.2.0.260. SQL Prompt works fine for the snippets and for the SQL built-in functions, but it no longer show...
Restoring database - Best practice?
I have my test-database in SQL Source Control which works fine.
Sometimes (about once each three months - or if I need live data) I backup my production database and restores it in my test environm...
Change default filter?
Hi,
As a new user of SQL Developer Bundle I still have a lot to learn! One thing that I guess is possible, which I cannot figure out is:
In SQL Compare 11, how can I set the application to OPEN wit...