Thanks for the feedback, Mike.

Yes, as much as I enjoy the little break from the office these conferences offer, I really couldn't justify going to one annually since, as you say, there aren't...

Many thanks. I'll check out that custom task you refer to.

Noel,

I think we are both saying the same thing here. I claimed that the default setting was that cursors would be created as GLOBAL.

This is congruent with your correct statement...

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 = object_id(N'[dbo].' +...

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