No worries, Steve. I'm sure nobody minded getting the easy point!

I'm not sure what happened here. I submitted the question last week and was asked if I wanted credit for it. I responded yes but then saw the question come...

I really can't agree with the 'paper tiger' argument against certification.

Sure there are people out there like this (i.e. lots of certifcations but not much real world experience) but a...

I definitely thinking certification is a good idea.

For one, it points out areas that you might never see in your day-to-day job and therefore, not even know about it. Not all...

Hello again.

I just realized that I posted this exact question several months ago and got the answer (which is to supply the date as 2004-12-31).

I sorta remembered this but couldn't...

In my last sentence, I actually meant to say ' ... or 01-01-2004' would work too'.

- Mike

Thanks Kathi. That worked for me also.

Strange how the order of the date value is so important. I would have thought 01-JAN-2004 or...

Thank you AJ but I'm actually trying to debug the stored procedure in Query Analyzer rather than execute it. If you right click on a stored procedure in Query Analyzer,...

Hello again.

Thanks very much for the tip. It worked!

Here is my procedure ...

CREATE PROCEDURE DBO.CREATE_TABLE (@TABLENAME VARCHAR(20))

 AS

DECLARE @sql VARCHAR(800)

f not exists (select * from dbo.sysobjects where id =...

Hi there.

Respectfully, I disagree with you (and Capri). Did you actually try this?

I think you (and Capri) are assuming that @TABLENAME will be resolved to the value of the parameter...

Capri,

Thanks but I believe your suggestion results in an existence check for [<A href="mailtoBO.@TABLENAME">DBO].[@TABLENAME]. In other words, the contents of the parameter @TABLENAME is...

Thanks for responding.

I was able to get around the unattended install problem I reported originally by going into the appropriate .iss file and changing the UpgradeMSSearch option from 0 to...

Hi again.

Is there any chance that IM_SUBITEM has an UPDATE trigger itself that updates the OLEINXFR table?

That would mean a recursive trigger exists and could explain what is happening.

- Mike

...

Hi Beth.

This certainly seems strange.

Have you tried reversing the order of the UPDATE statements within the trigger to see what happens?

Another idea would be to split these into separate triggers...

Hi Kevin.

Well, I sorted out my problem connecting to the remote workstation running SQL Server Personal Edition from another workstation.

Before I explain the problem, many thanks for your ideas and...