Very Computer

1. Running 2 different instances of SQL Sever.

We are migrating from SQL 7 ( SP3 ) to SQL 2000 ( SP2 ).

On the development server, we have 2 instances of SQL
Server running, one is SQL 7 ( Service Pack 3 ) and the
other is SQL 2000 ( Service Pack 2 ).

On the production server, we have only SQL 7 (Service Pack
3 ) running.

I have a SP that takes only 5 minutes on the production
server ( SQL 7 ), whereas the same SP on the development server ( SQL 7 /
SQL 2000 )
takes 30 minutes to complete on the SQL 7 & SQL 2000 databases.

I ran this SP using SQL 2000 Query Analyzer on both the
production and development servers.

My question is there any problem having 2 different
instances of SQL server running on the same server because
the SP on the development server takes lot of time to complete.

This SP is a report and is creating and populating 2 temp tables.

Any help would be appreciated.

Thanks,

Ashish.

2. MANUFACTURING RIGHT THE FIRST TIME

3. How to tell which version of SQL sever running

4. Newbie Help? 6.5 database to Sql2000?

5. Can Win 98 run SQL sever - newbie

6. Repeptitive strain prevention

7. Sql Sever locks out users when running select into or create databases

8. CommitTrans dbFlushOSCacheWrites, dbFlushOSCacheWrites not defined error

9. SQL 6.5 on single computer with no network?

10. Setup sql server on single computer

11. Error 1204: SQL running out of locks, but DB is in single-user mode

12. T-SQL debugger will run procedure, but won't single step and gives errors

13. Running batches of sql files by a single command