For example;

declare @cmd varchar(255)

declare @server varchar(20)

set @server = 'PROFILES'

set @cmd = 'select * from ' + @server + '...RAM'

exec (@cmd)

Install SQL Server 7.0 as default instance and 2000 as named instance so you can have both environment to develp sctipts for different needs.

Try example.

select *

from northwind.dbo.orders np

inner join pubs.dbo.orders pp

on np.orderid = pp.orderid

800 MB database is pretty small in SQL Server and it shouldn't impact the performance unless database, queries and tables indexes were not properly designed.

Try to run dbcc dbreindex your...

Create a view on the table to exclude the date column and let everyone accesses the view.

You could add additional BINARY_CHECKSUM column that returns the checksum value computed over a...

What do you mean Model database is not activated? Is it detached too? Satrt SQL Server with -T3608 and try to attach Model database back first, remove -T3608 and stop...

Try Multi Server Administration from SQL Server Agent.

Run performance monitor to see which processes are consuming the CPUs. Are any other applications except SQL Server running in same box?

If you comfirm the high CPU usage is caused...

You are right and it just checks to see that the backup set is complete and that all volumes are readable.

You are tring to access SQL Server with 'trust connection' from IIS server.

Option1 : create SQL Server login with proper permissions to your database and modify your ASP connection...

Agreeed with Michelle. Also want to add therer something you should do after migration, for example, move the queries into SQL Server as stored procedures, optimize queries and indexes tuning,...

It should work as long as the stored procedure returns row set that have same columns defined as your temp table.

Make sure all of columns have been assigned values when insert/update a row.

You may try EXEC sp_fkeys 'authors'.

Has clustered key defined on some columns in your destination table?