QUESTION POSED ON: 12 October 2005 I have copied my database from a Windows 2000 Server with SQL Server 7.0 Standard Edition to a Windows 2003 Server with SQL Server 2000. However, my views, stored procedures and triggers did not move. Everything else including the users transferred. What did I do wrong and how can I fix it?
>
It is hard to say what went wrong because I don't know what tool you used. I suggest you go to the 7.0 SQL Servers, generate the schema statements for your database objects (views, procedures, triggers, etc.) and then simply recreate them on the SQL Server 2000 instance.
Do you have comments on this Ask the Expert Q&A? Let us know.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
