Forum Replies Created

Viewing 15 posts - 271 through 285 (of 320 total)

  • RE: Logshipping

    is it really functional?

    but, the MSDN say different: http://msdn.microsoft.com/en-us/library/ms187103.aspx, directly on first paragraph!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: What is a good SQL Server strategy for copy/move database tables between two location in different networks?

    Use SQL Server authentication, instead of Windows authentication. I set up snapshot replication between two domains, and set up an SQL login specifically for that. It works.

    i agree!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Database Connection Time Outs

    I have to admit, that's a bit confusing. If it's less than 20, then it would work without changing from 20, wouldn't it?

    yes, really is confusing!!! and i tell...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Insert into table from other table while excluding duplicates

    Must have posted at the same time I was. 🙂

    forgive me, inconvenient!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Insert into table from other table while excluding duplicates

    Sean Lange (6/6/2011)


    This is functional but does NOT prevent duplicate data from getting into the destination as Paul's script does.

    this prevent duplicate, if target table is empty!!!!! I read the...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Insert into table from other table while excluding duplicates

    rfr.ferrari (6/6/2011)


    lgoolsby 86333 (6/3/2011)


    I have 2 tables:

    IDXRaw and INVOICES. Both tables have fields INVNUM and MEASURE. IDXRaw will have multiple records with the same INVNUM and MEASURE values....


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Insert into table from other table while excluding duplicates

    lgoolsby 86333 (6/3/2011)


    I have 2 tables:

    IDXRaw and INVOICES. Both tables have fields INVNUM and MEASURE. IDXRaw will have multiple records with the same INVNUM and MEASURE values. ...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: After changing sa password!

    what's the account service of SQL Server Agent?


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Transaction Isolation Level examples

    look this: http://msdn.microsoft.com/en-us/library/ms378149.aspx


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: 180-day trial SQL Server 08 Enterprise expired

    i think that developer edition is much more interesting! in the end, the content is same that Enterprise Edition!

    the post below, the procedure for change edition of your version:

    http://www.sqlservercentral.com/Forums/FindPost1116264.aspx


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: How to change the Domain Groups in Cluster Security Policy after installation

    the recommendation for clustered environment is you've the account service and domain group defined! before of implementation of cluster!!

    in order to avoid a change!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Database Connection Time Outs

    Jeff Moden (6/2/2011)


    I've found that most people are doing the wrong thing by simply increasing the timeout. Do you really want the users to wait for more than 20...


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Database Connection Time Outs

    the default value is 20! if value is less than 20 then try increase!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Database Connection Time Outs

    advanced tab, on property window for SQL Server, verify the property: Remote Login Timeout, it's specify the number of seconds to wait before retuning from a failed remote login attempt;


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • RE: Determine if different components are installed

    aMSDeveloper (6/2/2011)


    I got my answer from SSCrazy. A sincere request is, could you please edit your post and remove my name? I really really would appreciate it.

    Thanks.

    edited!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

Viewing 15 posts - 271 through 285 (of 320 total)