I wholeheartedly agree with you....but only if we are talking about what a real education / learning experience gives you.

In the case of MS (and probably other SW vendors) certification, it...

With regards to the final comment, I too have reached the conclusion that the Microsoft answer is not always the most sensible....or the most relevant for real-world scenarios. Which begs...

I would absolutely agree with netmikem. In addition, the trick I have used is to rate my answers on a scale of 1 to 4 (highest to lowest level of...

...and who said that russians were slaves of their system?

I'd always thought that Labour Day in the US was moved to September to NOT coincide with the European May Day holiday....probably because those of us on this side of...

Yes, I have heard about these strange objects called "db project".....

Any chance of usefull links with more information?]

Thanks

Could you please cover the aspect of integrated source control in a future article?

Thanks

See:http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=197882

OK, you're even more right. I did not double click on the line which would at least have highlighted where the error actually...

Sorry Remi, what I did was try and isolate the problem and provide the key element that was failing. The actual line that contained the error - as posted in...

....but why was the error message pointing to the wrong line in the code....

Yup, sorry I refreshed my browser and did not notice your reply on the second page.

As for the request to post the "original" code, that would not have helped given...

Here it is. I'm kind of hoping you won't also ask for all the related table and data scripts....

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS OFF

GO

if exists (select * from dbo.sysobjects...

I first noticed the error in a SP which contains a complex INSERT with the SELECT having many JOINS. So I then tried a cut down version on the two...

Truly bizarre. I am running SQL 2000 and have set the compatibility level 80.

Just to clarify, the script I posted was run on a new TestDB that I've just created. ...

OK,

below I am attaching a full sample script that also creates and populates the tables. It continues to give me the same error. Is no one else seeing this error?

As...