Hey mazzz,

Thanks a lot and may have to look at the Powershell avenue as well. The script you provided looks to be very useful. Thanks again

DHeath

This is a nice piece of code that will generate the needed code to make the change as well. Was written by a co-worker for me and if you...

[font="System"]If you need to change the owner of MASTER,MODEL,TEMPDB, or DISTRIBUTION either there's something horribly wrong with your installation or you are doing something really strange.

Tom Thomson

Na tog mi gun...

Ok update.... have tried to use the code snippit of

EXEC sp_MSforeachdb 'USE ?; EXEC sp_changedbowner ''sa'''

and running that on the master database but it errors out with

Msg...

Thanks...will have to read up on the CMS and give you an update as to what takes place... thats for the input...

DHeath

Thanks for the reply G-Squared =]

I am hoping to find something that is on the "free" side as you know how companies dont want to spend any $$$ they dont...

I would have to agree with G on this as far as modifying the code. That will also give you more knowledge of exactly what is going on and...

No need to add any more to this thread as (Microsoft Tool)SCOM was the chosen tool for this environment since such a variation in sql versions and the ability to...

I agree in both cases and responses above. My situation is similiar while coming into a position/place where the standards were minimal and the lack of that drives me...

My guess would be that the errror report /log files will read exactly as if they were in english EXCEPT in a differnt language soo i am thinking you may...

Hello there,

As for how you should set your procesors i cant comment as i dont know. =[ sorry

As for the main db with auto growth to 1MB... if i was...

In my eyes the biggest benefits of 64 over 32 is memory usage and taking full advantage of the newer hardware(true hyper-threading) that continues to come available you know HT...

Awesome thanks for the post... Why are you not going with a newer version of MSSQL? I am sure this problem will go away and... =] here...

A lot of it depends on what you have as your backup infrastructure (tape..disk to disk..SAN/LUNs..etc)

I would have you think of a product from NetApp thats called snapmanager and it...

Hello there,

the software today and it states is for “high-speed data mobility, migration, and protection between EMC CLARiiON networked storage and qualified storage systems” Since we don’t have clariion...