Forum Replies Created

Viewing 15 posts - 2,941 through 2,955 (of 3,366 total)

  • RE: How to import db data from the old mdb file to the new database?

    Sorry I misunderstand you all you need is to attach the old database in the AppData folder, try the link below for two ways to do it either through Management...

    Kind regards,
    Gift Peddie

  • RE: Problem Connecting to MSDE from Borland Database Engine (BDE).

    You need a full SQL Server 2000 you could still get the developer edition for under $20.00 online or if your employer own an existing license you could get the...

    Kind regards,
    Gift Peddie

  • RE: How to import db data from the old mdb file to the new database?

    If your ASPNETDB is located in the AppData folder you may run into problems retoring it to the IIS folder, if that happens you may look into restoring in Network...

    Kind regards,
    Gift Peddie

  • RE: How to import db data from the old mdb file to the new database?

    Backup and Restore the old database SQL Server will recreate everything and you can change the name as needed during the restore, one more thing there is no mdb file...

    Kind regards,
    Gift Peddie

  • RE: Help with an error

    Yep the automation subsystem depends on the Agent running with decent permissions but to explain how all work together will take sometime so Microsoft choose not to document it or...

    Kind regards,
    Gift Peddie

  • RE: Help with an error

    (* Proxy running the job, Credential bound to user LOCAL/Admin.

    * SSIS package with "Encrypt sensitive data with password" instead of "Encrypt sensitive data with user key".

    * Login with sql user...

    Kind regards,
    Gift Peddie

  • RE: To The Max

    The airlines sell Time so you need time interval arithmetic in algebra and calculus but their schedules and logistics is not regulated so they will not hire the mathematicians needed...

    Kind regards,
    Gift Peddie

  • RE: UPDATE is not allowed because the statement updates view "View_Test" which participates in a join and has an INSTEAD OF UPDATE trigger.

    There is no work around in 2005 because JOINS are idempotent that is they are not updatable per ANSI SQL and the same goes for view for more than one...

    Kind regards,
    Gift Peddie

  • RE: Who''s #1?

    BI just got more interesting Oracle buys Hyperion Microsoft caused that because last year IBM canceled its long term contract with Hyperion, but Oracle still needs to buy Informatica to...

    Kind regards,
    Gift Peddie

  • RE: The Remote Life

    I am very new here but your company issued laptop is your office because I work for someone in Alabama my go to person is in Elpaso and I am in...

    Kind regards,
    Gift Peddie

  • RE: Two Weeks

    Steve,

    Microsoft only made BI cheap but currently not easier, most companies need BI but they just don't know it, remember my reference about Jetblue time is their business they need...

    Kind regards,
    Gift Peddie

  • RE: MCDBA Certification

    Back here on planet earth all SQL Server 2005 should be out now because the last BI exam comes out February, 2007.

    http://www.microsoft.com/learning/mcp/mcitp/default.mspx

    Kind regards,
    Gift Peddie

  • RE: Two Weeks

    I got this from the Dobb’s Architecture mailing list interesting subject  if the dimension modeling is done right Jetblue could use it to create extraneous weather related staff logistics. I...

    Kind regards,
    Gift Peddie

  • RE: How Do You Import/Export Data?

    I am sorry I am trying to help but a 150 columns to one table does not qualify for the OLTP end of the relational model because I don't see...

    Kind regards,
    Gift Peddie

  • RE: How Do You Import/Export Data?

    One thing I have learned in software experts like Ralph Kimbal explains things in a few words in plain English, he wrote a book on ETL take a look at...

    Kind regards,
    Gift Peddie

Viewing 15 posts - 2,941 through 2,955 (of 3,366 total)