Thanks a lot. That is a great solution !! can you walk me thru how to setup that agent job to do the comparison?

Same server.

Thanks,

the recovery mode is set to simple (the deault). Can I change that to Full in MSDB with no issues?

Thanks

That is the weird thing, I have a maintenance plan that does all the rebuilding and reorganizing of the indexes on weekends and this happened on a Thursday; also when...

Autogrowth is set to unrestricted growth by 500 MB

No data imports, or index creation; I have been logging records growth for all tables and nothing out of the ordinary; the growth was only in the mdf file.

Windows 2003 Standard with SQL2005 Standard SP2

This is definetly a good discussion. Again mixed feeling, I wish somebody from MS developing team give us a light.

we have an equallogic iSCSI SAN and a 64 bit quad processor server. How much downtime should I plan for?

Thanks,

carlos

Thanks for the reply !!!

Thanks, I tried that but is there any way I can tell EM or Query Analyzer to assign dbo by default? It would become very complicated to try to find...

Thanks a lot !!!

THANKS SO MUCH !!! Worked like a charm.

I run a sp that is in the Master DB with those 4 statements:

execute sp_addrolemember 'db_owner','adcnt\SQLAdmins'

execute sp_addrolemember 'db_owner','adcnt\SQLFull'

execute sp_addrolemember 'db_owner','adcnt\SQLRW'

execute sp_addrolemember 'db_datareader','adcnt\SQLR'

GO

and I run this from the query analizer pointing...

I tried that but didn't serve my purpose. What I am actually trying to accomplish is to run a sp that is in the master Db so that I can...