<div>
are you speaking of this question:<br />
<a href="https://www.experts-exchange.com/questions/22893924/Restoring-SQL-Server-2000-db-to-SQL-Server-2005-db-user-issues.html" rel="ugc">https://www.experts-exchange.com/questions/22893924/Restoring-SQL-Server-2000-db-to-SQL-Server-2005-db-user-issues.html</a><br />
<br />
now, what is your exact problem?
</div>


are you speaking of this question:
https://www.experts-exchange.com/questions/22893924/Restoring-SQL-Server-2000-db-to-SQL-Server-2005-db-user-issues.html [https://www.experts-exchange.com/questions/22893924/Restoring-SQL-Server-2000-db-to-SQL-Server-2005-db-user-issues.html]

now, what is your exact problem?

<div>
OK! I changed all the prefixes in the code to dbo. Now everything works fine.
</div>


OK! I changed all the prefixes in the code to dbo. Now everything works fine.

<div>
<div class="content wysiwyg-content">
There is already a question with the same problem &quot;Restoring SQL Server 2000 db to SQL Server 2005 db user issues&quot; posted with a solution &quot;I got it. &nbsp;It seems there is an order to things. &nbsp;I can now run the sp's either way. &nbsp;I don't have time to write it up but I will in case someone else runs into this issue.&quot;<br />
<br />
But I can't find the solution in detail. How is it possible to get the solution.<br />
<br />
Many thanks
</div>
</div>


There is already a question with the same problem "Restoring SQL Server 2000 db to SQL Server 2005 db user issues" posted with a solution "I got it.  It seems there is an order to things.  I can now run the sp's either way.  I don't have time to write it up but I will in case someone else runs into this issue."

But I can't find the solution in detail. How is it possible to get the solution.

Many thanks

dbo Prefix after migrate from MS SQL 2000 to 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.