This piece of code works for SQL2k under Win2k, XP and Win2003. However, it's slow for XP & WIN2003 because winmsd seems to ignore switches and return everything under...

Ok, another shot in the dark.... any chance that there was once 15 columns in the table and that there's an object somewhere that references a now-missing column? Does...

Possibly an FK referenced or referencing column involved? Is the column you're trying to increase actually column 15 of object 892582268?

Cheers,

- Mark

Nothing else happening at the same time as the intregrity checks? Reorgs maybe?

Cheers,

- Mark

Thanks Johan. I'll give it a go on a SQL 7.0 box.

Cheers,

- Mark

...ok, there's 5 options to acheive this.

Cheers,

- Mark

There's 3 options to acheive this:

1. Only allow updates through a stored procedures that check the time of day before updating.

2. Put triggers on the tables to check the time...

That would be my expectation.

Cheers,

- Mark

You're not alone Anthony. It's happenning (or rather, NOT happening) for me too. It occurs from time to time.

Actually, the reduced incoming mail can be a blessing at...

SQLBill,

I can understand erroneous SPs being created ok due to Deferrred Name Resolution, but this is a syntax error that should prevent the SP being created.

October 15, 2003 at 3:30 pm

#478366