Synametrics Technologies

I am trying to compare a production SQL Server database with a non prod database. I have set up the ODBC connections with trusted connections to both servers and defaulting to the database I want to compare. On production I have read access, on non-prod I am SA. When I do the compare WinSQL only shows me that there are objects in my non prod database and not production, so it does not show me any differences. Thoughts?

Kevin, What happens when you connect to your production database in a regular window. Are you able to fetch objects? Second, are the owners same in both databases? Regards, JS >I am trying to compare a production SQL Server database with a non prod database. > I have set up the ODBC connections with trusted connections to both servers and defaulting >to the database I want to compare. > >On production I have read access, on non-prod I am SA. > >When I do the compare WinSQL only shows me that there are objects in my non prod database >and not production, so it does not show me any differences. > >Thoughts?

I tracked it down to sp_stored_procedures is not returning a list of procedures. I can see all the procedures via EM, but this proc for some reason does not return the list. >I am trying to compare a production SQL Server database with a non prod database. > I have set up the ODBC connections with trusted connections to both servers and defaulting >to the database I want to compare. > >On production I have read access, on non-prod I am SA. > >When I do the compare WinSQL only shows me that there are objects in my non prod database >and not production, so it does not show me any differences. > >Thoughts?