heh, I've spent the last 7hrs trying to install and configure an Oracle9i personal edition database. Talk about fricken unfriendly app. You go into their 'enterprise manager', select...

Just did some poking around and I am getting an ole automation error message on the example I did.

OLE Automation Error Information

HRESULT: 0x8002801d

Source: ODSOLE Extended Procedure

...

Nothing with SCHEMABINDING.

How deep CAN dependencys be nested and still work? I think that might be the issue. 'A' needs 'B' needs C,D & E.

I think they do get...

Yes and Yes.

I seem to recall reading somewhere that this was by the nature of views what happens. Just didn't know if someone knew a 3rd party widget or...

*smacks forehead*

Perfectly obvious now that I'm looking at it.

Thanks,

Chris

hrmmm... I thought I had replied to this almost after I wrote it.

I had been futzing around and clicked the auto close button.

After I stopped swearing at the machine and...

awesome article. Thanks!

Chris

edit: Of course now... how can I go thru and quickly rename 450+ procs 🙁

Learning is painful.

Edited by - ctklein on 10/27/2003 2:31:23 PM

rtompkins hit it on the head. After I posted my original msg I went in to my boss to ask him what he was thinking. Long and short...

alot of the processing in calculateonerc.asp is dependant upon conditional scripts. Its seemingly easier to do a loop thru records in vbscript than to do cursors within SQL (possibly)

I...

scary, eh?

I've inherited some of this code since the 'senior' dba left here and now I'm the 'senior' dba. (oh joy, oh rapture)

Running your version of the proc vs. the...

Hi there!

Thanks for the info. Guess that being a footnote and not CUBED makes the number more manageable. 🙂

Regards,

Chris

Hi there,

I have been looking thru the BOL and I cannot anything definitive that says something along the lines of 'its recommended that you have at least <x> memory per...

Hey there 🙂

Thats cool, its pretty much what we're doing now... Maybe I didn't phrase the question right. Currently we're using the SA account for all of the mydbuser,...

Actually I was able to knock out something last evening:

Select A.* from ExteriorWallCodes A INNER JOIN

(Select min(intID) as intID,vchrCode from ExteriorWallCodes

Group by vchrCode) B

ON (a.intID=b.intID and A.vchrCode =...

Hi There!

If you look in:

<drive>:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\sqlrepl

where ever you installed SQL there are a number of code samples that will help with replication and the CE platform.

Also, you can...