Hey

Ah you used a global temp table and exported out.

This works fine, thanks for the help, much appreciated

Regards

Matt

AH forgot to mention, I'm restoring the same database but from a different server with different database permissions. It's actually a refresh from production to non-prod

Hey Guys

Is there anyway to get these results returned by DBCC SHOWCONTIG through a system view. I've been using sys.dm_db_index_physical_stats but this doesn't give the extent fragmentation.

Reason being is that...

I can see criticism without an alternative solution??

To anyone still reading this (that is not kicking and screaming and has some common sense) this is offered as a solution to...

To anyone still browsing this forum. A way around shrinking a log file which wont shrink is by creating a new one and deleting the old one through moving the...

Hey Guys

I'm currently trying to create a table with a partition key that is not part of the primary key, but afetr I create the partition function,scheme ansd table and...