Unfortunately not, i checked the length yesterday and it only came to roughly 3000 characters. I'm obviously missing something really simple but i just can't see it!

why do i keep coming back with NULL when i run this???

CLR and OLE are enabled and registered RICHTX32.OCX.................any ideas??

BlueIvy, did that program work? got a similar issue myself and windows defragger can't defrag the files.....

thanks for the confirmation Andras! i've tried it through MS (ideally going to be running it through a stored proc) and checked the change script and it basically creates a...

thanks for that peter but i don't actually want to drop the column itself, just the idenity from it.

so just to clarify, i want to keep this column exactly as...

i'd use xp_cmdshell - keeps things simple!!!

do u have a test environment???? sample some large imports using that to see how much TLog space u need.....

may be that bulk-logged may b a better option......

are you're fragmented tables small tables? do u have a fill factor set?

can ya not use a CASE statement???

i'm getting the same but not as frequent. i read this:

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/17/10-0-plan-cache-flush.aspx

and none of those commands that trigger this message are being ran unless its and internal sql thing??

I'm...

try

EXEC master.dbo.xp_cmdshell 'ren c:\test.txt c:\test.001'

hi danster, i fully agree with ya, i'm finding things that used to take a min or 2 can take double if not treble the time and effort!!!!

its as if...

is there a way to rebuild/defrag the indexes of a system table? just done a showcontig on sysobjects and the indexes r a mess!!!!