Forum Replies Created

Viewing 15 posts - 271 through 285 (of 1,179 total)

  • RE: fail job scheduled when package fails

    Open the job step on which you do have issue and select advance property. See the value of 'On failure action' this might be setup wrongly?

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

  • RE: script to find the roles

    SQL server contains login and user related information in the tables syslogins and sysusers. Check out the required information for your audit.

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

  • RE: rebuild increases memory

    Not clear, what exactly are you looking for? Are you facing any issue on the server?

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

  • RE: Object already exists, but can't drop it!

    What kind of permission do you have on server? If you do not have permission than too such kind of error message pop up.

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

  • RE: It's Not All About The Keys

    Thank you, Andy for question.

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

  • RE: Create a table using script

    I guess vinodhkumargv is looking for simple solution and could be...

    Copy .txt code and past it to the new query windows and execute it. It will create the table.

    HTH

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

  • RE: Implementation of SQL2012 vs SQL2012

    If your application supports and all testings are OK than you should go with SQL Server 2014. There are advantage of new features of SQL 2014 and also it will...

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

  • RE: restoration issue

    If you think that your backup is corrupt you can use RESTORE VERIFYONLY to check if the backup is good?

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

  • RE: unexpected data gorwth?

    Make sure you enable Instant Initialization for filegrowth and than set filegrowth to 10 GB.

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

  • RE: SQL 2012 Clusertring AlwaysOn- Primary and Secondary Replica

    Refer following link:

    http://www.sqlservercentral.com/articles/FCI/92196/

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

  • RE: Temporary Tables and Statistics in Stored Procedures

    Very interesting question!!

    Thanks!

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

  • RE: Transfer of Logins from 2k to 2K8

    Perry Whittle (4/10/2014)


    Jake Shelton (4/10/2014)


    My question is whether I need to move the logins to a 2k5 box as an interim step before relocating again to 2008.

    No you...

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

  • RE: unexpected data gorwth?

    If your datagrowth is 1 GB/Day; I suggest to set FILE GROWTH by 5/10 GB. Also think about storage too.

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

  • RE: Login failed, error 18456

    Great!!

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

  • RE: Login failed, error 18456

    Also confirm what is the status of login 'NT AUTHORITY\SYSTEM'?

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

Viewing 15 posts - 271 through 285 (of 1,179 total)