Try running DBCC CHECKDB to see if you have any errors.

Yes, I've used it. I redirect event logs to my server to fire alerts and execute jobs and send email notifications.

Check for your network speed because you may have...

Try exec sp_serveroption 'Servername','Data Acess', True

GO

Select * from servername.dbname.ownername.tablename

Try also deattaching you db , and then attaching it again. There, through EM you can specify a new db owner

I Would recomend transactional replication. You can replicate identity values but to prevent errors or discontinued values, you must set the identity column like not for replication. Check BOL for...

I thinks that it has to be with permissions in the operating system

In wich recovery mode your database is?

In sysindexes you have the first page of the datafile. The one that SQL uses to start scanning an index.

You can't know the pages an index has. With the undocumented...

Any error that you can post?

if you have a slow network maybe you should change the packet size. Also check the client and server net library. In slow networks TCP/IP works better than Net Beui

...

Also check for the script in

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=473

It scan all indexes in the db and report a status of fragmentation.

If SQL uses a table scan then the optimizer decided not to use the index. You could force sql to use the index with hints but i don't recommend it.

...

Also check in BOL for the Full recovery mode of SQL 2000. Maybe you should consider it.

A fild with no data in it is just a null value. I don't think you can.

Also you could script the objects that you want to move and then imports the data of those objects.