You thought about running BACKUP LOG <DB> WITH NO_LOG and then running DBCC SHRINKFILE(' <logname> ', truncateonly) ?

Before migrating to Win2K make sure that you check out possible application issues related to differences in MDAC versions.

Your cache hit ratio should be up around 99%. You are probably running a lot of ad-hoc queries against this box (at least I hope so) to get a hit...

Sounds like a problem with your initial install of SQL2K. Check the install logs and see if there were any problems, also check the System and Application event logs to...

A google search will come up with a whole boatload, top of the list http://www.devasp.net/Net/Articles/Randy/TraceFlags.asp

How about using activex to move through the list and for each moving the data?

You can set the aliases in the registry, they are located under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo

You could set the keys here and display the info in EM.

Would creating aliases with the suffix in them not work for you?

I would recommend checking as often as possible (daily if you can) the index fragmentation level on the tables that are used in the slow queries so that you can...

You will receive an error upon attempting to install. You might be able to bypass this, install 7.0 and get it working, even if you do it will not be...

Above is the proc that does the majority of the work...it will go through, check the indexes on each table and then insert into a perm table the results of...

Modifying the boot.ini has no effect in Windows 2000 Server. To take advantage of the extra memory you would need to run Windows 2000 Advanced Server.

The whole thing is pretty involved...I'm going to look at creating an article for it...but the basics are that you want to run a dbcc showcontig for all the tables...

I work with a lot of small (<500,000 rows) tables and find that they have to be reindexed frequently. To help with this I have created a job that goes...

Good question. Only knew the answer as at my previous company we spent about a week trying to figure out the answer to this problem.