Forum Replies Created

Viewing 9 posts - 1 through 10 (of 10 total)

  • RE: Updating from 2 tables

    Thank you so much

     

  • RE: Updating from 2 tables

    How would you use a union in an update.  I have tried but is receiving a error

    Msg 170, Level 15, State 1, Line 9

    Line 9: Incorrect syntax near ')'.

     

    Code

  • RE: BACKUP failed to complete the command

    I finally recieve an error that the process had timeout.  I know with InstallShield can set this value, but can I set it in script as well?

  • RE: BACKUP failed to complete the command

    I'm just running a general backup script similar to:

    use master

    go

    if (select count(*) from sysdevices where name = 'DB_Data') = 0

    EXEC sp_addumpdevice 'disk', 'DB_Data',

       'D:\SCDATA\DATA\DB_db.bak'

    go

    dump database cad to DB_Data

    go

     

    In MS...

  • RE: ODBC Connection

    One more thing:

    >ODBC reports that the server does not exist, but when I create a new data source the server appears in the dropdown.

  • RE: Group By

    How do you use Max()/Min() when you're trying to sum columns. I thought these functions will return the max and min values not a summation.

  • RE: Changing tables

    Thanks

  • RE: MSDE Install

    Thanks,

    Works perfectly

    Thanks again

  • RE: MSDE Install

    Thanks, but where and how do I change it? Is there docs available?

Viewing 9 posts - 1 through 10 (of 10 total)