Do you have any ideas on how to test this? The only 2 tests I did were not conclusive.

I must be blind now... what's wrong with the last suggested query?

So do you still need help, or you're fine?

This is a known problem. Thank you for helping make this site even better.

I'm sure you did, but just in case : Did you delete all the cookies, local files from IE?

CREATE TABLE #Test (a VARCHAR(30))

INSERT INTO #Test (a) SELECT REPLICATE('A', 29)

ALTER TABLE #Test

ALTER COLUMN a VARCHAR (29)

--this works fine

DROP TABLE #Test

GO

CREATE TABLE #Test (a VARCHAR(30))

INSERT INTO #Test (a) SELECT REPLICATE('A',...

Maybe it's in high penetration for the new licenses, or new customers. But that does not account for old machines being reinstalled with 2000. After all this is...

Just for those who don't have Acces to see what I mean, see attached file.

So what was the root of that problem??

I'm still not conviced. I understand the logic behind what is said that it is better to check prior to make any changes... but I would assume that MS...

Maybe we should all start using ACCESS as GUI for SQL Server.

As far as I know, we all script everything we do anyways, so there's no point to keep SSMS...

Not that I know of. I like what they did in Access 2007, but it doesn't appear to be possible in SSMS (Express anyways).

:w00t:, after 3 times you'd think that it would be enough. So I won't tell you again.

I will however suggest that you can have this functionnality by moving the...

23 MB left instead of 23 GB? That will make a small difference :w00t:.

I don't have the right name, but if you search for utility in books online, you will get that list and sample code.

The QOTD section also has a section for...