Thanks all.

When you say you use GUI to change dbowner, how do you do that?

Thanks

So what you do is a simple step like below:

USE dbname

EXEC sp_changedbowner 'sa'

Is that correct?

Thank you. Sorry I didn't make it clear.

I do use my window authenticated login- my own username to create databases.

What I mean is if the database is created in the...

This is very helpful. Let me study what you said, it may take me a little bit to totally understand this. Thank you.

Also I think this is also related with job owner.

Does sql agent job run in the context and permissions of the SID, or of the service account, or job owner?

Still a little confused, so when a sql agent job runs, it runs as the SID, or runs as the service account we use?

In our case we have two servers...

I checked this is a window 2003, 32 bits, 2 gb memory.

The memory setup uses the default of sql server.

Thanks

Thank you, it's helpful!

Thank you all.

So even the sa account is disabled, I can still change the job owner or database owner to sa account, is that correct?

If so, just curious how...

Thank you, it helps a lot.

Can I find this any where documented in SQL book online, would like to find more details.

We do monitor 30% too.

So inow I know if space is run out on database data, log drive, database will crash.

How about backup drive?

Thanks

Please help me to understand what you said, i found all these little helpful tips and I save it in text files, but it's hard to pull quickly out when...

And I see in sql server 2008 there is a sql agent service account, NT AUTHORITY\SYSTEM.

Is it better to change job owner to this account?

Thanks all.

So first I do need to enable sa account, correct?

For maintenance plan, I found that you have to change owner to the plan too, if you only change job...

Thanks, the article helps a little bit.

So if there is no tie in, then if we use that domain account which run sql agent service for other purpose for example...