Toad World® Forums

Suggested Object Name on Save shows wrong database name prefix


#1

Do this:

Connect to Server A, Customer Database ABC

Generate a SQL Script to a window.

Connect to Server B, Go to the Script you generated above, right-click, change connection to Server B connection, choose Database Y

Run the script on Server B Database Y.

Click the Save button.

Expected: that suggested file name would be:

View DatabaseY.dbo.ViewName.sql

Actual: Toad suggests that name should be:

DatabaseA.dbo.ViewName.sql

This is confusing because DatabaseA is not the database I’m looking at right now. I may have made changes to the view since it was originally generated.


#2

Dear Darren,

Thank you very much. I create TSS-858 for this. We will discuss wether we will change this.

Best Regards,

Kelly