New answers tagged configuration
I would recommend using SSIS. As it has the flexibility to allow you to save the package and reuse it for subsequent runs and it can even be scheduled using sql agent job. You are also compromising security by allowing ad-hoc distributed queries to run (changing it to 1). I have tried the exact same query that you posted and it works for me. sp_configure ...
Not sure if I fully understand the question. But the internal applications should be fine about the port number unless there are also firewalls internally, in which case you just allow the port through there. For the external access, I'd consider a static port so you can stop doing what you have to do. In an ideal world you'd only really expose your SQL ...
Under Windows this information is stored in the Registry under the key: HKEY_CURRENT_USER\Software\pgAdmin III In Linux systems I would expect some file in the user home directory.
Top 50 recent answers are included