Brian,

I have seen this also in my nephew's league to the point where parents get ejected and find it disturbing. What kind of sportsmanship are they teaching their kids?...

It's a great idea for an enhancement but I don't know of any way to do it at the enterprise level. Stamey is right in that EM does remember...

Thanks a lot Andy. I was asking for another Sys Admin here who supports this manager. I would say at the least he's probably in for more than...

Procrastinators - here is your justification for postponing installation of W2K SP4: http://www.w2knews.com/anecdotes.htm.

Note that 2 post SP SQL Server problems are mentioned along with a successful multi-server...

SQL Server Licensing is per processor, not per server even if you're going to downgrade to 7.0 which does make a big difference on a quad processor system.

This is probably...

Thank you very much Allen and that was what I suspected. It makes sense the way you put it.

Legato is managed by our network admins therefore I don't really...

I am quite curious about this as well due to the vulnerabilities that are supposed to be addressed by SP4 (see thread under Security). Anyone else care to share...

We're in a similar situation to SQLBill's with one of our applications. Virtually every update that the vendor sends has a script at the end that grants rights for...

I know this is an older thread but had to revive it just to put in my two cents. I personally work with MSSQL 7/2000, Sybase 12(no me gusto...

If you can afford a little downtime another really simple method is to shut down SQL Server, make a copy of the data and log files (using a different filename),...

Another point about MSDB. Not only does this contain all of your job schedules, it also contains your job History. If you use scheduled jobs to perform your...

Cool - Thanks!

So from QA I can just update the 'originating_server' in the sysjobs table? I did verify that it still lists the old server name here. Then...

Thanks.

It's not that frequent and usually happens once after a restart, although sometimes will pop up in the middle of the day for no apparent reason. I was just...

Oops - forgot

You'll also want to get your network guys into the loop as well. I think the router tables can freak on some systems if...

We did this with very few problems a couple of months back. In addition to renaming the servers, you may also need to re-map your user ID's or you...