Hi everyone,

I read the BOL about DBCC SHOWCONTIG, and they mention how to defragment a fragmented index, but they do not mention how to defrag a fragmented table. What...

Steve, I stand corrected on the rebuild mishap. Sorry about the confusion.

I am sorry for being confusing, by rebuild I meant, update, sorry. If anyone knows of a way that we can make large number of updates to a table...

Ah, just saw the System Event Logs and it seems that we may be having a network adapter problem here.  I'll update you when I find out more info...

Hi sa24,

The job owner is sa.  The job has been running consistently for years...with few interruptions here and there.  We are not using a proxy account.

BTW, we get a lot of connection errors.  How would I troubleshoot connection errors?

Thank you for your help everyone.

Steve, the user used to run create table from QA and the owner of the new table would automatically be dbo.  He has some jobs...

Hi everyone,

Unfortunately we still have not found an answer to this problem. 

Can someone please explain to me the following?

If I create a database, add a user, give him/her db_owner...

Thank you!

Hi Bill,

The owner of the database is someone else, which is the same person who was the owner when things were working. 

I recently also installed MDAC 2.8.  Could this...

Hi Steve, thanks for your reply!

This is a critical server.  The database is working fine, and so is the win 2000.  I am not familiar with internal errors, am I...

raven, if I do that, will all users with db_owner permission, have sa permissions?  Are they going to have all of the system admin permissions?

I just remembered one thing that...

sa24, yes he was db_owner before.  Nothing has changed.  I just dropped his account and re-created it again and still have the same problem.

Hi Gavin, thank you for your reply. 

I am aware of sp_changeobjectowner.  However, there is a bunch of code that is written which do not specifically tell sql server to...

Great responses, thanks for your help.