We have seperation of duties.  All promotions (data/schema) come through the DBA's.  We have an audit trail of paper.  The developers fill out a form for the promotion.  Their manager...

Yes.  We use clusterd primary keys.  Where the primary key is not clustered, we generaly have a compound index clustered on fields that are more commonly used in the "where"...

2048 is our standard.  In some cases we end up zipping down the files and ftp them from one site to another.  This is basically a convience and standards issue. ...

Thanks, that did the trick!

Joseph

I removed/installed SQL Server and it fixed it.  I will keep the last two postings in mind for the next time it happens.

thanks,

Joseph

Windows 2000, sp4.

My co-workers (3 of us DBA's) were out.  They have the same thing happening.  Something has to have changed in our enviroment for all three machines to get...

I understand what you are saying, but I don't know how that will help.

All the information is in the registry, how does importing and exporting it help?  I will give...

None of my passwords have changed.

In the registry, I found where the groups and instances are.  I have played with it and it is only picking up the first group...

I have found the registry setting where the information is stored.  All the databases I registered yesterday are there.  Now I need to find why the Enterprise manager is not...

No, I don't know of anything that would be modifing my registry.  I will look further.

Thanks,

Joseph

My suggestion for the tempDB would be go back to the application.  I know the tempdb is not backed up.  If there are too many users and/or the application is...

What version of SQL Server are you running and what is the patch level? 

Do you have your transaction log on seperate disk from the database files?

Are you running backups...

That gave me the information I needed.  But I would still be interested if any one knows the Hex algorythm.

Joseph

Thank you very much for your help.  My problem was caused by a parameter change in a restore.  We use TDP Tivoli from IBM to backup or databases to a...

Thanks Steve for the new group. 

If/when I get this other query figured out I will post it.

thanks