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...

  • RE: Text Column Updates

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

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

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • RE: SET IDENTITY_INSERT NOR WORKING

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

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

  • 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...

  • RE: MCITP DBA numbers - so few

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

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

    Very nice article 😎

  • RE: DateTime

    you are wellcome!

    :hehe:

  • 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...

  • RE: Snapshot each 15 min...

    GilaMonster your code works like charm so so thnx!

    Wilfred van Dijk thnx anyway!

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

  • RE: Snapshot each 15 min...

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

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