Forum Replies Created

Viewing 15 posts - 61 through 75 (of 318 total)

  • RE: Back up

    If you are asking if you can stop taking backups of the database once it is on the DEV server, of course. However, I would highly recommend you either...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Sql server Agent stops working

    Are there any entries in the logs? Start with the SQL Error Logs and then move to the Windows Logs.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Re-Installation Failure

    If you do not or cannot reinstall the OS - take a look at the following:

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: OLE DB Provider for DB2

    This may be what you are looking for -

    http://www-03.ibm.com/systems/i/software/access/index.html

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Does your employer assume you have broadband internet?

    My previous two employers paid a portion of both my cell phone plan and broadband internet. Recently I switched to Sprints mifi (all couriers seem to have this option...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Restore SQL 2005 db and sys dbs from prod server to test

    Use Master

    Alter Database [insert db name here]

    SET SINGLE_USER With ROLLBACK IMMEDIATE

    RESTORE DATABASE [insert db name here] FROM DISK = 'E:\backup\insert db backup name here.bak'

    WITH REPLACE

    GO

    Tweak as needed.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Installing SQL Server 2005

    Not to nitpick, but even the article referenced stated - "On a computer that has a multicore processor, you may be unable to install SQL Server 2005"

    The optimal word being...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Re-Installation Failure

    Most likely you did not completely uninstall SQL Server. There are numerous sites if you do a Google search that go into great detail of exactly what and where...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: SQL Server Agent not running jobs

    Just a guess, but you may have hit the maximum job history log size.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: issue with rebuildm.exe

    What are you attempting to do? Rebuild the master database? Change licensing? Collation?

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Maintenance plan not saving?

    Are you accessing the Maintenance Plan wizard/tool via SQL 2000 Enterprise Manager or are you attempting to create a plan using SQL 2005 Management Studio remotely?

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Migrating Databases from SQL 7 to SQL 2005?

    Unfortunately you must do a step upgrade when SQL 7 is involved.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: SQL Server Trying to Run a Job That DOES NOT Exist

    By chance is the mystery job actually associated with a old Maintenance Plan?

    Check that Job ID against the sysmaintplan_subplans table

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: error 1418

    Could you post the solution for others that may have a similar issue.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: error 1418

    Please attempt to use the IP address instead of the server name.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

Viewing 15 posts - 61 through 75 (of 318 total)