:w00t:!, the only that comes to mind quickly is rewrite the damn thing. HOwever I'm sure you've considered that option and ruled it out. The only other option I...

I see all the filters in the inner join (except for the is null)...

Select w.* from webs w

LEFT JOIN docs d

ON w.id = d.webid

and w.id = '12345'

AND...

What was the problem? Your solution will surely save someone's butt someday so it would really help him if you could post the solution ;).

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).