Problem solve Get help with specific problems with your technologies, process and projects.

Difficulties transferring stored procedures and triggers

If you're having difficulty migrating data from SQL Server 7.0 to SQL Server 2000, Monitoring and Administration expert Kevin Kline helps you rectify the problem in this expert response.

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.

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.