Why not do an SP_WHO2 and see who is connected to what. You could monitor that for awhile and you should get an idea as to which of the 49...

It shouldn't be too much of a nightmare as the search ability it going to be limited to a specific date and not a range. So all we will need...

Believe me if I could do it any other way I would. You see we need to keep live data for 90 on line, and all archive has to be...

It is for a monthly archive and there is around 3Million rows a month that will be archived.

Was right before my eyes, thank you very much for you help.

Thanks for all the responces.....

Let me try and answer your questions David.

1. Because they powers that be request the results in such a formate.

2. The application will know....

3. there is...

Martin,

It sounds as thought the primary datafile your 'MyDATABASE' has a finite size which has been reached therfore not allowing the datafile to grow which it needs to do inorder...

Yes it is, as no changes are done to the user databases by the application of SP4. It is all done against system databases.

I should have read your question correctly the first time.....

Your problem is that SQL Server 2000 ENT ED will only support upto 8GB of RAM under WIN2K Adv Server. Since...

I have it configured on a WIN2K ADV Server. How have you configured your boot.ini file ?

We have set 7GB for SQL server this is configured statically in EM and...

Boy do I need a STRONG cup of coffee....I forgot to creat the startup acount as a domain account.

DUH !!!  

Problem has been...

Use DTS for this, it is the easiets way.

To delete the user from the sysusers table you will need to first either through EM or QA set the property to allow you to make changes directly to the...

Over the years I have found the follwoing script to be most use full

DBCC OPENTRAN (DBNAME)

SET NOCOUNT ON

   DECLARE @LogicalFileName sysname,

           @MaxMinutes INT,

           @NewSize INT

   -- *** MAKE SURE TO...

My understding was or is that SP 4 makes changes ot the systables in the user databases as well as the standard changes which is why it is impossible to...