Viewing 15 posts - 1 through 15 (of 20 total)
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...
December 10, 2003 at 2:00 pm
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
...
November 26, 2003 at 9:02 am
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...
November 25, 2003 at 9:03 am
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...
November 24, 2003 at 8:21 am
*smacks forehead*
Perfectly obvious now that I'm looking at it.
Thanks,
Chris
November 20, 2003 at 10:44 am
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...
November 3, 2003 at 8:38 am
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
October 27, 2003 at 12:20 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...
October 27, 2003 at 6:51 am
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...
October 24, 2003 at 11:58 am
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...
October 23, 2003 at 2:42 pm
Hi there!
Thanks for the info. Guess that being a footnote and not CUBED makes the number more manageable. 🙂
Regards,
Chris
July 16, 2003 at 6:39 am
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...
July 14, 2003 at 8:55 pm
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,...
July 10, 2003 at 9:41 pm
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 =...
June 26, 2003 at 7:05 am
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...
June 25, 2003 at 7:35 am
Viewing 15 posts - 1 through 15 (of 20 total)