Is the database configured for full or simple recovery. I'm guessing full..

You could do:

DUMP TRANSACTION databasename WITH NO_LOG

GO

DUMP TRANSACTION databasename WITH TRUNCATE_ONLY

GO

That should clear up the log..

CEWII

I guess I come back to the fact that for there to be a clean methodology I either need to have a delimiter or a set size to chop off...

You are very welcome..

CEWII

In SQL 2000 the services packs for SQL and Analysis are installed seperately. So I don't think so.. But you should still test..

CEWII

I believe DBCC SHRINKFILE is available in SQL 2000.. Look at that..

CEWII

This is typicially handled with an SSIS package template. You create one package and then use it as the basis for other packages. Other than that not really...

Service packs are cumulative so just install SP4 and all the changes from sp1-sp4 will be applied.. Just run the EXE file you get from MS..

CEWII

I tend to agree however most organizations end up having to live with mixed mode. And their audit group learns to live with it..

CEWII

Test it, test it, test it..

There is no way to tell whether there will be a problem with your particular implementation.

However, I wouldn't apply hotfixes unless you are actually experiencing...

I agree all those questions need to be answered, I have found that it is fairly rare to be in Windows only authentication . I have only had a...

I think the end result of that discussion was that there wasn't significant differences between the several methods. How you are going to use the data was the single...

How do you know to split it at:

AUDITR 0287 Location

How would the system know that?

CEWII

In the context of my life I can't see wanting to do this. But in the context of the server that would be pretty cool, I just don't what...

I think you are probably barking up the wrong tree with those logins..

Can you create maintenance plans from another server? Also I don't userstand the statement "Computer...

Right, log growth(or database growth) KILLS performance, so if you set the growth rate to a reasonable rate then it won't be too bad, but I don't think you'll see...