Forum Replies Created

Viewing 15 posts - 1 through 15 (of 20 total)

  • RE: Any way to restore an Oracle backup into SQL2K?

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

  • RE: Writing to text files within a SQL Stored Proc

    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

    ...

  • RE: scripting views

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

  • RE: scripting views

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

  • RE: grouping not grouping right(maybe?)

    *smacks forehead*

    Perfectly obvious now that I'm looking at it.

    Thanks,

    Chris

  • RE: server taking a dirt nap...

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

  • RE: procedure naming prefixes

    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

  • RE: Open source SQL database engine/Linux

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

  • RE: calling procs thru ASP, performance degrade

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

  • RE: Performance question... TSQL streamlining...

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

  • RE: memory and concurrent users

    Hi there!

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

    Regards,

    Chris

  • RE: memory and concurrent users

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

  • RE: SQL accounts for Crystal Reports or ASP app

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

  • RE: select distinct problem...

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

  • RE: Replication in SQL Server CE & 2000

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

Viewing 15 posts - 1 through 15 (of 20 total)