Forum Replies Created

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

  • RE: Bug in dm_db_index_usage_stats?

    Can you update the stats for the table and then run the index_usage?

    ----------
    Ashish

  • RE: Database log file full, Mirroring , please help

    Shrinking will not help here as your log will grow again. I will suggest two option:-

    1) Read Gail article which she referred in earlier reply.

    2) Reduce the frequency of your...

    ----------
    Ashish

  • RE: Database log file full, Mirroring , please help

    1) what does this command reflect for your database:-

    select name,state_desc form sys.databases

    2) How frequently you doing the log backup? If the interval between the log backup is high then consider...

    ----------
    Ashish

  • RE: monitoring sql servers

    good SQL server monitoring tool and in affordable price?

    as you have raised this query in sql 2008 forum, I beleive you using sql server 2008.

    So I will suggest start...

    ----------
    Ashish

  • RE: Invalid Object - 0x80040E14

    so the invalid object which I referred, does exist? Give more detail as what you doing within your package.....like from which table to which flat file(txt file or something else)

    ----------
    Ashish

  • RE: Retrospective Password Policy

    check policy and check expiration, both are different thing.

    Check Policy :- When you will configure the password, it will check the policy that password mentioned is matching the policy or...

    ----------
    Ashish

  • RE: Invalid Object - 0x80040E14

    its quite hard to predict the reason without knowling your dts/ssis, but from the error, it seems like the object not exists.

    Description: "Invalid object name 'teoco.IDDMOUBYV_ROUNDEDDLYTRMCAR2011-04-01-2011-04-30'

    ----------
    Ashish

  • RE: Database Mode

    clustering is at server level and for server high availability not the database. So even if your perticualr user database failed to bring online, it doesnt mean that perticular database...

    ----------
    Ashish

  • RE: How to read Log file in Sql Server

    Can any one tell me how to read log file (like what transaction happened etc) in SQL SERVER.

    if you have litespeed tool and you have upgraded it to 5.0...

    ----------
    Ashish

  • RE: NEW SEQUENCE NUMBER DAILY?

    I need to reset a sequence number every 0000hrs daily...

    can you explain where exactly you have to reset the sequence?

    Is this a table column or something else. Please provide...

    ----------
    Ashish

  • RE: Replication latency

    latency is a kind of counter which give you information on how much time it take subscriber to get updated.

    In your case as its transaction replication with updating subscriber...

    ----------
    Ashish

  • RE: NEW SEQUENCE NUMBER DAILY?

    you can have trigger which will be fired as per requirement and will do the activity as scripted.

    ----------
    Ashish

  • RE: SQL Server Destination required to use Windows Authentication

    But it fails when I switch to SQL Authentication.

    not sure if you referring this switch within DTS/SSIS.

    If that is the case then for SQL server windows authentication and...

    ----------
    Ashish

  • RE: Separate db copy for reporting

    if the secondary server database is purely reporting purpose then you can consider log shipping where you will be restoring the backup(full or log) with standby option which will leave...

    ----------
    Ashish

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