Forum Replies Created

Viewing 15 posts - 421 through 435 (of 1,179 total)

  • RE: DATA Base mail configuration using GMAIL - Giving error

    Can you try 'ssl://smtp.gmail.com', and port '465'

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: SQL Server Agent : Job Failure

    There are two approach:

    one is you can use notification feature of the job to send e-mail notification when job completes i.e. success or failure.

    Second is you periodically check the job...

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Please help with SQL SERVER 2012 express 32bit

    Check the installation file to make sure no file is missing/corrupt. Have you done any successful installation with this installation file.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: SP Recompile

    One way to track is to create trace with SQL profiler.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: with clause select statement take long time to run.

    Have you checked the execution plan? Attached the execution plan so people can help you.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: DB in suspect mode after Log shipping restore

    Rund the DBCC CHECKDB command to find further information.

    Refer following link for the actions to resolve the issue:

    http://social.msdn.microsoft.com/Forums/en-US/ea8b251f-fbce-4f8b-8a87-1b570688ce88/suspect-database-recovery-sql-server-2005?forum=sqldatabaseengine

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: OPENQUERY-2

    Interesting question, thanks Carlo.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Indexes

    Thanks and appreciate all your comments!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: How to format a query

    Are you lookin for following link?

    http://sql-format.com/

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Extended Event system_health

    Why you would like to do that? What you want to achieve?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: How to learn SSIS

    There are many books available in the market on SSIS and get any book with good rating to start with is a good idea.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Bad Days

    Who ever supports in PROD environment experience like "butterflies flying in my stomach" and I guess that would be the BAD DAY!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: SQL 2008 Mail Setup

    I am not sure if any relation between Display name and Exchange server?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: How to repair .mdf file?

    If above solution won't work. Use latest good backup to restore the database. Make sure in that case you might have data loss. Hope this is not your production server....

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: User database moved to "System Databases" container

    What is the name of the database?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 15 posts - 421 through 435 (of 1,179 total)