Activity overview
Latest activity by ralphtrickey
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?
Grabbing Schema from different server than the connection
This is a bit of an oddball request.
If it possible to grab the schema from a different server than the server that the connection is pointing to?
Here's a scenario. I have 4 servers that I connect...
Required access to master..sysservers
Is it possible to not require access to master..sysservers? There are a couple of machines where I don't have permission to access that table, and the dbas aren't likely to grant me access to it.
I...