Forum Replies Created

Viewing 15 posts - 241 through 255 (of 286 total)

  • RE: Create trigger on Insert

    Robert klimes (6/19/2009)

    check out the link on how to create triggers. http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx

    here is something to help you get started

    create trigger trig_name

    on table_name

    after insert

    as

    declare @seq varchar(25)

    set @seq = (select max(substring(caseid,charindex('-',caseid)+1,len(caseid)))+1...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 19, 2009 at 3:16 pm

    #1012688

  • RE: Account gets locked out

    Adam Bean (6/19/2009)

    Is it an NT account? Have you checked for the conflicker worm? If not, do they have fat fingers? 🙂

    Hi,

    It is a SQL user account. I have no...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 19, 2009 at 9:48 am

    #1012520

  • RE: Account gets locked out

    Andy Hogg (6/19/2009)

    Hmm try this.

    Next time the account is locked out, open the login properties and uncheck "Enforce password policy".

    Then "ok" that. Then go back into the login properties and...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 19, 2009 at 9:18 am

    #1012497

  • RE: Database Mail

    S Hodkinson (6/12/2009)

    I have set up database mail on one of our servers and can send myself a test mail. However when I set up an operator, database mail...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 17, 2009 at 9:10 am

    #1011038

  • RE: Row-by-Row comparison

    rvkhadava (6/5/2009)

    I have two tables, stg,main with the same structure.Each day data is refeshed into stg from the flat file. And from there into main.Before the main table is loaded,I...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 17, 2009 at 8:39 am

    #1010994

  • RE: Transaction Log shipping

    But a little bit confusion- Is it necessary to give the Networkpath and Local path destinations eventhough my primary and secondary databases are on the same Server itself? or else...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 17, 2009 at 8:31 am

    #1010977

  • RE: Moving SQL 2005 to new server

    Is there any other best practice to be followed for moving sql server.

    I would go for mirroring, as it has an ease of setting up and in case you want...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 17, 2009 at 8:20 am

    #1010961

  • RE: SSIS issue

    mithun.gite (6/11/2009)

    Hello Everyone,

    I am facing a small problem while creating the SSIS package.

    I have a requirement -

    The user needs to upload a file in one of the tables in...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 16, 2009 at 10:37 am

    #1010332

  • RE: correpted mdf file

    aa2home (6/9/2009)

    HI I have a old backup from my corrupted mdf file but the ldf is OK. Can I restore the DB

    Thanks anyway

    Hi,

    What version of SQL server u are...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 11, 2009 at 7:07 am

    #1007975

  • RE: duplicate records

    Tara (6/2/2009)

    How do i find duplicate records in a database of 1.3 TB where in we dont have any PK's ( this might surprise you). I am trying to pull...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 4, 2009 at 10:00 am

    #1004750

  • RE: mdf file increasing a lot !!!

    GURSETHI (6/3/2009)

    Hi,

    I think this document has explained things pretty well (diff between SP_ATTACH_DB & ALTER DATABASE). A small curx of it.

    So why exactly is this important, and what difference does...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 4, 2009 at 9:28 am

    #1004726

  • RE: Loading Flat file into SQL server 2005 using SSIS

    RBarryYoung (6/3/2009)

    Do you have Logging turned on? What does it say is happening?

    Hi,

    The package runs OK in BIDS. It does not give me any errors, but I am concerned...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 3, 2009 at 1:59 pm

    #1004275

  • RE: Maintenance plan error in MSSQL2005

    sameer_bhagat_1 (6/2/2009)

    Hi,

    I have Server 2003 Enterprise edition X64 and One Mssql 2005 X64 Instance with SP3.

    I have created Maintenance plans on it for backups, reindex, reorganize etc.

    .Net framework installed...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 3, 2009 at 8:04 am

    #1004034

  • RE: Loading Flat file into SQL server 2005 using SSIS

    RBarryYoung (6/2/2009)

    "First time" after what? What do you do that resets it?

    Hi,

    I am not resetting the package. But when I run from BIDS for first time, no data gets...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 3, 2009 at 7:07 am

    #1003969

  • RE: SQL Server maintenamce plan errors

    HI Aatish,

    In just one maintenance plan, it is not a good idea to include index rebuild and index reorganize. You can use a script (modify it as per your req.)

    http://sqlfool.com/2008/10/index-defrag-script/

    in...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    May 18, 2009 at 9:11 am

    #996414

Viewing 15 posts - 241 through 255 (of 286 total)