this is for a customer that is anxious to try sql2008, but the app is not quite 100% upgradable yet.

Thank you all for your responses.

I found those out too, going through each of them.

luckily, I have and will try the Red Gate X-SQL bundle.

Hopefully, it will save me some...

in Houston, only people with death wish are bikers. There are very few bike lanes, and mostly for recreation only, meaning in parks and such places. Have anyone try to...

Thought I hold the record of longest commute, but I guess Karma beats me to it, my one way drive is only 46 miles. I wish we have some kind...

Damon,

You just describe my guy to a T.

great advice! thanks.

Maybe you did work at the place I am currently employed.

I will try your solution.

Many thanks for the feedbacks.

First of all, I'd like to appologize to Jeff and those that were misled to beleive that I am the other guy.

I am the poor sod...

Jeff,

Yes, we have SQL Server running on Windows.

I think apart from installing SQL and SPs, for what the DBA needs sys admin privs? It's not that we do not...

he is a system/operation DBA.

why the need?

there are already system administartors to do all OS stuffs.

is there some way to limit the size of the error logs, for example 2 or 5 MB each? Would appreciate any pointers/advices.

do a backup ASAP

a little detail: does the server need a reboot? or just a SQL Server service restart is enough? Thnaks.

G, thank you very much.

Thank you all for the info.

George et al, to use the -n flag, do I have to create a new key in the registry? for example, SQLArg3 with value -n?...

For starter, I want to know who and when some one logs in the database. The the built-in SQL security auditing does just that (logins success/failure) but I want the results...

do you have any numbers regarding this "huge negative performance impact"? has anybody actually done a case study? please give some samples. Thanks.