Forum Replies Created

Viewing 15 posts - 12,601 through 12,615 (of 49,557 total)

  • RE: Hai all

    The SQL Server service account (the account that SQL server is running under) needs full control of all folders where databases exist.

  • RE: Restore Incomplete BAK file

    Try RESTORE ... WITH CONTINUE_AFTER_ERROR on SQL 2005 or above

    It's highly unlikely to work, but you can try. If it doesn't work, then the backup is useless.

  • RE: Microsoft Certified Master

    Vedran Kesegic (6/21/2013)


    Comparing that to Gail's 15 minute walk from home to test center, makes me jealous ๐Ÿ™‚

    15 minute drive, and that test center no longer exists, so the next...

  • RE: Restore Incomplete BAK file

    Please post new questions in a new thread and include error messages in text (you can copy from any error dialog in SSMS)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/20/2013)


    So this morning I've been frantically searching the internet on articles to help clarify a problem I'm experiencing, and what do I see?

    Gail Shaw's name all over the...

  • RE: Change the system date to future date in desired database

    Not possible. The system date is the Windows system date. This shouldn't be changed as it can cause problems with Kerberos tickets.

  • RE: dead lock

    Don't understand the question

  • RE: record stored in log

    In multiple log records that describe the change and how to undo it.

    What are you trying to discover or fix?

  • RE: How will work with(nolock) option in select queries

    DiverKas (6/21/2013)


    Knowing when its safe to use a particular solution or even more importantly when NOT to use a solution is really what people need to understand. Blanket statements...

  • RE: An issue with my Execution plan

    To be honest, I don't have time right now, or for a couple of weeks.

    Go hit my blog and look for a post on user-defined functions, IO statistics and the...

  • RE: SQL Locks

    Why? What is that total number going to tell you?

  • RE: index statistics updation

    Maybe, maybe not. Depends on the tables, the data patterns and the queries that run.

  • RE: Need Help:Error log

    DKG-967908 (6/21/2013)


    why donโ€™t you recycle SQL error log by exec sp_cycle_errorlog.

    It's not that his error log is growing, it's that SQL is stack dumping and writing large stack dumps into...

  • RE: Hai all

    Nothing to do with any relationships between NETWORK and SYSTEM. The service account that SQL Server is running under does not have permission to that folder. Check what account SQL...

  • RE: 'sa' password getting reset

    Create a trace (or look in the default trace) for security events. I can't remember offhand which event it is, Books Online will have details.

    p.s. Why are you using the...

Viewing 15 posts - 12,601 through 12,615 (of 49,557 total)