Comments
Sort by recent activity
So did you complete the puzzle? And does anyone have good suggestions for future Easter Eggs? / comments
So did you complete the puzzle? And does anyone have good suggestions for future Easter Eggs?
Rob,
I have posted a reply to most of your comment in the other post.
Yes speaking as a tester who was feed up of typing out all those messages into fault reports, that is a great tip. The simplest ideas are always the best.
Regards,
Jonathan / comments
Rob,
I have posted a reply to most of your comment in the other post.
Yes speaking as a tester who was feed up of typing out all those messages into fault reports, that is a great tip. The simples...
Jamie,
I amended my test case to be only on SQL 2005 dbs, but unfortunately I still cannot recreate the issue. I take that it is effecting all types of objects; tables, procs and function etc?
If it possible, can you please email a copy of your database or an example of the problem to jonathan [dot] watts [at] red-gate [dot] com and I will be able to have a closer look at your problem.
Regards,
Jonathan / comments
Jamie,
I amended my test case to be only on SQL 2005 dbs, but unfortunately I still cannot recreate the issue. I take that it is effecting all types of objects; tables, procs and function etc?
If ...
Hi Jamie,
I have been trying to reproduce your problem using the method you describe.
At the moment [y].table doesn't get shown at all
Unfortunately I cannot cause the failure you describe, all the objects in the script that I ran at step 5 do appear in the comparison. They all have a status of identical after I set up the dbo->JenasysDesign mapping.
I take that you are using an original db on a SQL 2000 server and a blank db on a SQL 2005 server?
The only thing that I think of is that mappings should be set up in both directions, i.e. in db1 dbo should be mapped to JenasysDesign and in db2 JenasysDesign should be mapped to dbo. Therefore you should create a user in you original 2000 db called JenasysDesign and map it to dbo in the blank database.
Hope this helps,
Jonathan / comments
Hi Jamie,
I have been trying to reproduce your problem using the method you describe.
At the moment [y].table doesn't get shown at all
Unfortunately I cannot cause the failure you describe, all ...
Thanks we try to get this fixed by the final release, if not the next beta.
Regards,
Jonathan / comments
Thanks we try to get this fixed by the final release, if not the next beta.
Regards,
Jonathan
Hi there Mike,
Thanks for your patience and the test script. I can confirm that the we get the issue too. However, I am not sure at this stage when a fix will be ready, I will have a word with the development team and will get back to you in the next few days.
Regards,
Jonathan / comments
Hi there Mike,
Thanks for your patience and the test script. I can confirm that the we get the issue too. However, I am not sure at this stage when a fix will be ready, I will have a word with the ...
Hi there,
Thanks for your feedback. Unfortunately it looks like SQL Prompt has reacted badly to the SQL Refactor Lay out. If it is possible can you email the script that you were refactoring at the time to jonathan dot watts at red-gate dot com?
Regards,
Jonathan / comments
Hi there,
Thanks for your feedback. Unfortunately it looks like SQL Prompt has reacted badly to the SQL Refactor Lay out. If it is possible can you email the script that you were refactoring at t...
Hi there,
Thanks for your feedback. Unfortunately it looks like SQL Prompt has reacted badly to the SQL Refactor Lay out. If it is possible can you email the script that you were refactoring at the time to jonathan dot watts at red-gate dot com?
Regards,
Jonathan / comments
Hi there,
Thanks for your feedback. Unfortunately it looks like SQL Prompt has reacted badly to the SQL Refactor Lay out. If it is possible can you email the script that you were refactoring at the...
Hi dineshasanka,
You do not have to open the stored procedure to rename it. You should be able to generate a rename script just clicking on the Smart Rename option in the context menu and entering the new name.
Regards,
Jonathan / comments
Hi dineshasanka,
You do not have to open the stored procedure to rename it. You should be able to generate a rename script just clicking on the Smart Rename option in the context menu and entering ...
Hi Sylvain,
Thanks for you message, we will get a fix in for this by the final release if not the next beta release.
Many thanks
Jonathan / comments
Hi Sylvain,
Thanks for you message, we will get a fix in for this by the final release if not the next beta release.
Many thanks
Jonathan