You do not mention if the 2 instances are on the same 'virtual' server or not. If they are on the same 'virtual' server then 'alias'ing and registry hacks are...

Before re-indexing I'd execute DBCC CHECKALLOC first ...

My 'standard' DBCC 'triage' is:

    DBCC CHECKDB

    DBCC CHECKALLOC

    DBCC CHECKCATALOG

also besides the forward slashes in the "FROM" clause ... "G:" (G colon) is not correct. A colon is not part of a valid UNC name either. If you are doing...

noeld ... short, sweet and it'll work !!!

Try searching for LogicalFrag in BOL, it responds with DBCC SHOWCONTIG. I believe it's example "E".

Habving just started Oracle DB support (oh about a year ago) I have some idea of what you are looking for from SQL2000 from an Oracle perspective. Unfortunately at present...

Anything 'virtual' is something that appears to be there but really isn't.

Oh, by the way, my spelling is not great but my pronunciations is usually on 'target' ...

It's pronounced "squeal"...

The delay may be in ms but that is per hop taken and they are cumulative on initiasl login. Dependent on your network topology this can be significantly more than...

I just couldn't resist commenting on that since I'm a confirmed 'java junkie' ... Have a Great Day !

SQL Enterprise and better on a server with 4Gb or more RAM:

    boot.ini needs /3GB switch

    via sp_configure set your 'max server memory' to 3072 MB (3 Gb)

    (you may...

Access violations are not good. What SP are you on ? Could you upgrade to SQL2000 ? It's possible that you are being 'bit' by a fixable 'bug(s)'. Have you...

about "Note to self: Never work in DB before second cup of java has kicked in "

I'm just curious what happens when you get...

Just a possible explanation on why WA seems slower ... First it's probably only slower on initial login to the server. I state this because once you are authenticated all...

This should work. processadmin has KILL as a permission. Maybe you have not refreshed your EM. Try shutting ot down and relaunching it (I do not trust the 'refresh' function...

... lest we forget the 'final' SQL script ...

    exec sp_update_resume

    go

    if @database_restore = "success"

        if @data_loss = "none"

            exec sp_kudos_to_dba

        else

            exec sp_distrubute_resume

            --exec sp_pack_up_desk

    else

          exec sp_distrubute_resume

           --exec...