Forum Replies Created

Viewing 15 posts - 256 through 270 (of 286 total)

  • RE: how to enable auditing in sql server 2005

    anjan.ashok (5/6/2009)

    I am using Enterprise edition with sp3.

    Did you installed SP3 recently? check the log file of sp3 installation as may be due to some failure in sp3.

    Hope this helps...

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

    May 7, 2009 at 9:35 am

    #990435

  • RE: Job step edit error

    vmenon (11/4/2008)

    Please can you try out the following:

    RUN AT THE COMMAND PROMPT ON SERVER: REGSVR32.EXE dts.dll

    You can fing the dll file at the location :\Program Files\Microsoft SQL Server\90\DTS\binn

    Hi,

    I had the...

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

    May 4, 2009 at 8:07 am

    #988098

  • RE: Database Mail

    Todd,

    Try the following:

    account name: your SQL server instance name

    PORT: let it be the default

    smtp: your smtp server name (smoething like smtp.gmail.com)

    authentication: use any (like windows, SQL server or any)

    The...

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

    May 1, 2009 at 5:59 pm

    #987638

  • RE: Maintenance Plan - System Databases - More than just backup?

    mjcnospam-general (4/28/2009)

    Thanks to all who replied. This helped me get on my feet!

    Best,

    Mike

    HI Mike,

    This is a very good article by Brad M. McGehee

    http://www.sqlservercentral.com/blogs/aloha_dba/archive/2009/04/16/the-maintenance-plan-wizard-can-lead-you-astray.aspx

    It gives you a brief idea of...

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

    April 28, 2009 at 9:14 am

    #985205

  • RE: Index Fragmentation

    radek (4/24/2009)

    Hi,

    I have clustered table with few nonclustered index. I need to do defragment.

    Which indexes firs? The clustred ? I think? ,then nonclustered? If I understand it correctly...

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

    April 25, 2009 at 9:31 am

    #983973

  • RE: Connection to SQL server 2005

    dmc (4/22/2009)

    You may have an issue with your VPN setup. Kind of hard to tell without knowing more about your setup. Can you ping your test server, telnet,...

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

    April 22, 2009 at 11:20 am

    #982365

  • RE: Index Fragmentation

    GilaMonster (4/20/2009)

    Except for the first one, all the others are far too small to even worry about fragmentation.

    Hi,

    Thanks for your quick reply. Just curious, how did u tell that "others...

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

    April 20, 2009 at 2:49 pm

    #981050

  • RE: Need to know what SQL code is generated by application

    Jack Corbett (4/17/2009)

    What about using replication?

    Hi Jack,

    Replication came to my mind first. But when I analyzed my situation, it is not a good solution to implement.

    In my situation, the...

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

    April 17, 2009 at 7:35 am

    #979662

  • RE: Need to reflect changes made in test to Production

    noeld (4/14/2009)

    Let me explain why I said that.

    - Replication can affect the Publisher if the subscriber is down. So Do you really want to affect Production if TEST has a...

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

    April 15, 2009 at 7:50 am

    #978076

  • RE: Need to reflect changes made in test to Production

    noeld (4/14/2009)

    Replication from TEST to PROD or from PROD to TEST is never a good idea.

    Thanks for your input..

    But my requirement is that what ever the change is made to...

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

    April 14, 2009 at 12:04 pm

    #977507

  • RE: Overwrite data in excel using SSIS

    Princess (4/1/2009)

    Hi,

    I have creted a package that gets data from a table and adds it to a excel worksheet. The problem is everytime I run the packge it appends to...

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

    April 2, 2009 at 9:10 am

    #970812

  • RE: Find out duplicate rows from multiple table

    Jeff Moden (3/4/2009)

    ... and, no... sorry... I don't know how to write a script to do it for 300 different tables auto-magically... no way to know which columns make up...

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

    March 5, 2009 at 12:18 pm

    #954290

  • RE: Find out duplicate rows from multiple table

    beezell (3/4/2009)

    This sounds like a bit of a complex problem. The issue will be that each table has a different column that will identifiy it as being duplicated. ...

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

    March 4, 2009 at 5:19 pm

    #953713

  • RE: Restore Script

    klnsuddu (2/18/2009)

    Hi,

    Could you give some simple Restore script. I found some on this forum, but I need some to understand.

    1.to restore full backups to different drives

    2.to restore diff backups

    3.to restore...

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

    February 19, 2009 at 7:45 am

    #946684

  • RE: Another Licence Question.

    Simon Smith (2/12/2009)

    Just a quick question on licencing (again) as I can`t deduce the answer from Microsoft.

    I have 10 SQL servers licenced on a CAL model and 10 SQL servers...

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

    February 13, 2009 at 8:03 am

    #943629

Viewing 15 posts - 256 through 270 (of 286 total)