I have a php script where I need to access tables in two different MSSQL
databases.
The scenario is . access 1st database to retrieve data that will be
used when calling a StoredProcedure within the 2nd database which will
return data with which one can access the 1st database to retrieve mo
This sounds like your MSSQL connections are getting mixed up.
If the two databases are on the same server and the same sql login has
access to both databases you can query everything from a single conenction.
You just have to qualify the tables/procedures with ..table
to the server knows where to
