What a great discussion!!

I would even like to see the vendors create everything on a schema level without regard to the name of the database, let alone a...

Good Posts!!

Just remember not to confuse the 'Density' of a statistic with 'fragmentation' in an index. These are two completely seperate topics.

Your second post has a lot to do with where I am at. I have 8 10GB datafiles in one filegroup. The first 2 datafiles are at about...

Does anyone know where I can learn why Constraints are better than triggers. BOL explains that they are but do not directly say why. At least not that...

I recently migrated databases in the same fashion and everything went well. 7 sp3 to 2000 sp 2.

If I were in your shoes I would try isolating the problem....

I am curious as to why you didn't go with Oracle on NT?

I work with both databases and I think you will find the Oracle end users adapting easily. ...

It is somewhere in the msdb database...I think 🙂

Thanks Steve,

I ended up hacking the registry yesterday and getting the SQL Server installation removed off both of my cluster servers.

Not the right way to do it, but it did...

You may also want to try creating a stored proc that TRUNCATE's the table, and is called instead of the delete's.

Make sure the owner is the same for the stored...

Seen it!!

This happened to me when I was trying to install mixed versions. Make sure you are going from Enterprise to Enterprise editions, or Standard to Standard.

I do not of any configuration file either.

The settings for the registered servers have to be stored somewhere. Maybe even in the registry. I don't know.

I guess what...

Thanks!!

I never knew I could do that through 'Design Table', but I found it 🙂

fyi-I traced the execution through profiler and found that it dropped the table and...

Thanks Steve. I was playing with that and it is just amazing what the paranthesis can do 🙂

Today, I feel like a rock!!!

Thanks!

Thanks Steve, I had been testing things and finally worked through it, and you were dead on with that. Here is the before and after code...

I alos recommend rebuilding the table if possible. A DBCC DBREINDEX on a clustered index does not truly remove the fragmentation of the data pages. There are a...