Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 1,136 total)

  • RE: daily checklist

    sanketahir1985 (9/2/2009)


    any one is having automated daily checklist?

    kindly upload here sample daily monitoring sheet if any one is having.

    not quite sure what you are after, you mention a automated checklist,...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Useing Role

    Omar halwagy (8/31/2009)


    i have add a database role and then choses and from the securables tab i assigned a spesfic table to deny insert

    then go to user on the...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Audit trailing sp_configure

    Kaushik Kumar (9/1/2009)


    Anyone knows how to audit trail sp_configure executes? or even find when the instance config values were changed and who changed them?

    Thanks

    Well for a start, if you change...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Advice Needed for MS SQL DBA Changing to a career with Oracle

    Steve Jones - Editor (8/28/2009)


    There definitely seem to see more jobs in the BI sector, especially SSIS in the US. Not sure about the UK.

    I think anything you can do...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Creating a new user there appears to be default permmison set up

    just out of curiosity, does this happen if you create the login and the user, using t-sql rather than through the gui. and do you have any triggers setup either...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Are the posted questions getting worse?

    Is it just me or do the same people constantly ask the most basic questions almost on a daily basis, which they could answer themselves in minutes by either google...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Advice Needed for MS SQL DBA Changing to a career with Oracle

    RTaylor2208 (8/27/2009)


    Hi,

    I know that this site is for MS SQL Server but I am in a bit of a rut, I work for the scottish health service and through all...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Redistribute memory

    thierry.vandurme (8/27/2009)


    total memory is 8Gb. SQL instance 1 is using about 7.5Gb of it. I suppose if we add memory it would even grow so can I assume the server...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Any problem with main page this site.?

    bit slow this morning, but apart from that ok. i would look at your network

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: sp_helpdb not working

    kiranmca24 (8/27/2009)


    Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53

    Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________0001000000DA'; column does not allow nulls. INSERT fails.

    The statement has...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Redistribute memory

    thierry.vandurme (8/27/2009)


    Hi all

    we have a server running two SQL 2005 instances (Standard edition). At the time of installation noone bothered to configure the min/max memory settings. Now, of course,...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: SSC Points

    Thanks very much, you missed the 1 in front of the 326 but that is ok 😉

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: Audti Trial for a single user

    WAGalaxy (8/24/2009)


    Hello

    For business requirements I want to create another sysadmin account called "sa2" and give it to the Software Developers/Business Analysts to use so they can perform their duties. What...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: SSC Points

    Sorry about the slight delay - been tied up with a couple of other bits and pieces - should be getting onto it today!

    Free software, eh? Not sure just having...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • RE: What can i do when Database Mirroring Certificate expired?

    create a new one.

    this might help you

    http://rusanu.com/2008/10/25/replacing-endpoint-certificates-that-are-near-expiration/

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 15 posts - 1,036 through 1,050 (of 1,136 total)