Forum Replies Created

Viewing 15 posts - 721 through 735 (of 789 total)

  • RE: Text Column Updates

    as I can see all of us were correct with UPDATETEXT statement but the question has the correct answer with Update col .... and all we are incorrect members for...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Text Column Updates

    Yes, the correct is Updatetext ...since we have things to do the update with text!

    LOL! :w00t::w00t::w00t::w00t:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Raid situation

    so the answer is 1 disk! Ok a didn't have any idea how many but I choos 2 disks in the logic that the RAID 5 should be with 3...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Raid situation

    Ellis RemoteDBA (6/6/2008)


    I think if its anything other than 1 it would not be a RAID 5 solution.

    Hmmm... can you explain more why just adding one disk and still in...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Strange Clustered Index Update

    hmm interesting situation why the column should be the Primary Key column but on the other hand it is not clustered till it is primary key! ok ok everyday we...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: How to get data

    For deleted data you can use trigger on DELETE!

    so for the uncommitted data you can use

    BEGIN TRANSACTION

    T-SQL code here ...testing here and finally if you want to do...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: SET IDENTITY_INSERT NOR WORKING

    I didn't use it so often couz I worked allways with DBCC checkident and allways working with latest data...so I need it today and doesn't works and it makes me...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: SET IDENTITY_INSERT NOR WORKING

    HAAAAAA I fixed it !!! now works OK OK OK

    the problem was NOT FOR REPLICATION .... :hehe::hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: SET IDENTITY_INSERT NOR WORKING

    I try ON and OFF but the same results ... the original error msg is :

    Msg 8101, Level 16, State 1, Line 1

    An explicit value for the identity column in...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: MCITP DBA numbers - so few

    interesting info, but how about SQL Server MVPs, how many of them!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: SQL Overview IV - DBA's Morning Review

    Very nice article 😎

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: DateTime

    you are wellcome!

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: DateTime

    Hello geethag6,

    It's impossible to avoid what you are asking in SQL Server 2000 or SQL Server 2005

    It would be possible in SQL Server 2008 you can test if you...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Snapshot each 15 min...

    GilaMonster your code works like charm so so thnx!

    Wilfred van Dijk thnx anyway!

    :hehe::hehe::hehe::hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Snapshot each 15 min...

    thnx! for info I like this short script from GilaMonster ...I'm trying :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 15 posts - 721 through 735 (of 789 total)