Comments
Sort by recent activity
chris.buckingham wrote:
You can do this by looking at SQL Prompt Options/Connections and look on the Login Credentials tab, and creating a New connection to SQL Servers and databases.
Unless I'm missing something, it's not quite the same thing. What I'm talking about is that I might make the connection in EM to SQLPRD01, but I want to connect to SQLDEV01 to grab the schema. That way I know that SQL Prompt can't possibly do anything bad to SQLPRD01, but I can still get most/all of the functionality, at the cost of occasional funkiness if the schemas get out of sync. Does that make sense? My other choice is to write the query on SQLDEV01 then copy it to SQLPRD01 to run it.
Thanks,
Ralph / comments
chris.buckingham wrote:
You can do this by looking at SQL Prompt Options/Connections and look on the Login Credentials tab, and creating a New connection to SQL Servers and databases.
Unless I'...
chris.buckingham wrote:
Unfortunately you have to be a member of a group that has read access to this table in order for Prompt to work.
Why? / comments
chris.buckingham wrote:
Unfortunately you have to be a member of a group that has read access to this table in order for Prompt to work.
Why?