Forum Replies Created

Viewing 15 posts - 211 through 225 (of 286 total)

  • RE: SSIS foreach Loop - creating dynamic log output files and sending email

    John Rowan (12/2/2009)

    Sorry for the delay on this, it kind of fell off my radar. The intent of my last question was to learn which control/data flow tasks you've...

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

    December 2, 2009 at 6:59 pm

    #1086848

  • RE: SSIS foreach Loop - creating dynamic log output files and sending email

    what I want to enhance is :

    If a user runs 3 files e.g update.sql ; delete.sql; count.sql

    the log file should be update[datetimestamp].txt; delete[datetimestamp].txt; count[datetimestamp].txt

    I am able to figure out...

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

    December 2, 2009 at 3:42 pm

    #1086809

  • RE: SSIS foreach Loop - creating dynamic log output files and sending email

    John Rowan (12/1/2009)

    How are you executing the SQL scripts against the DB?

    here is what is set up now and is working fine.

    There is a folder for each DB server, under...

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

    December 1, 2009 at 1:45 pm

    #1086102

  • RE: SSIS foreach Loop - creating dynamic log output files and sending email

    Hi,

    Can you give any example for this or any reference. I have tried implementing logging but it does not take the file name which ran against the database and some...

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

    December 1, 2009 at 11:12 am

    #1085977

  • RE: Database mail strange issue

    Jack Corbett (12/1/2009)

    Have you seen this thread in the MSDN forums?

    Thanks Jack,

    After I posted, I came across the same post. Let me give a shot ! 🙂

    Thanks,

    \\K

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

    December 1, 2009 at 10:59 am

    #1085974

  • RE: batch files

    CANCER (11/29/2009)

    Can any one help me how to write or include the below scripts in to batch files and run on multiple server to get details...

    ****************script to get builtin/admin acc...

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

    November 30, 2009 at 10:00 am

    #1085516

  • RE: SQL Server 2005 Automatic Backups

    manikam_sundar (11/16/2009)

    Hi Friends,

    Is it possible to perform Automatic Backups (ex: Daily at 8...

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

    November 18, 2009 at 10:30 am

    #1081059

  • RE: Attach/Dettach - automate

    Piotr.Rodak (11/13/2009)

    I like to write scripts that generate scripts to execute. Please switch SSMS into text mode results and have a look this:

    To generate script that will detach databases you...

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

    November 18, 2009 at 10:04 am

    #1081036

  • RE: Update table with changes

    smthembu (11/2/2009)

    Hi All

    I need a code to write data into another table if the data has changed from the source then update the destinaion

    Thanks

    How about SSIS to achieve this.

    e.g. compare...

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

    November 3, 2009 at 12:08 pm

    #1074439

  • RE: Linked servers

    josantia (10/23/2009)

    Hi,

    Some time ago, I did an script in Powershell to do that:

    http://practicascomunes.blogspot.com/2008/08/utilizando-poweshell-con-sql-2005-smo.html

    It's written in spanish, but you can translate in google.

    Hope it helps.

    Regards.

    JSO

    Thanks for the info. The site...

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

    October 23, 2009 at 8:21 pm

    #1070327

  • RE: Memory Settings for SQL server 2005

    Can you provide the link for that or any info.

    Thanks,

    \\K

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

    October 13, 2009 at 3:24 pm

    #1065420

  • RE: rebuild order, logins or db's?

    You can attach the database first and run the script for the logins to recreate them.

    Thanks,

    \\K

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

    October 13, 2009 at 11:21 am

    #1065311

  • RE: Update table if any new data added to list

    Elliott W (9/22/2009)

    SQL_Quest-825434 (9/22/2009)

    Second issue, the excel spreadsheet must contain some identifier so that it can decide that a record has changed as opposed to a new record.

    Hi,

    Can you elaborate...

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

    September 22, 2009 at 8:06 pm

    #1057248

  • RE: Update table if any new data added to list

    Second issue, the excel spreadsheet must contain some identifier so that it can decide that a record has changed as opposed to a new record.

    Hi,

    Can you elaborate or give some...

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

    September 22, 2009 at 9:46 am

    #1056903

  • RE: How to get the blocking details..

    Hi,

    You can try this ....

    SELECT

    t1.resource_type,

    'database' = DB_NAME(resource_database_id),

    'blk object' = t1.resource_associated_entity_id,

    t1.request_mode,

    t1.request_session_id,

    t2.blocking_session_id,

    ...

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

    September 3, 2009 at 8:35 am

    #1048784

Viewing 15 posts - 211 through 225 (of 286 total)