What are the challenges you face when working across database platforms? Take the survey
Options

exstended Stored Procedures

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited October 26, 2004 7:01AM in SQL Compare Previous Versions
Hi,

Thanks for writing us. SQL Compare is only concerned with SQL database schema, so we do not compare Extended Stored Procedures, since they are binary files and it would be extremely difficulty to pinpoint the relevance of the difference in two extended procedures.

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Mark,

    Because SQL Compare uses ADO .net, all of the queries that it runs rely on some stored procedures such as sp_executesql. These are stored in the master database. Which procedure, in particular, is giving the problem?
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Can you please tell us a bit about what this stored procedure does and why it is accessed during a database comparison?
This discussion has been closed.