Forum Replies Created

Viewing 15 posts - 11,776 through 11,790 (of 49,562 total)

  • RE: How to fix Logon trigger issue

    Not the error message that you get. Open up the SQL Server error log and see if there are any errors in there that may suggest why the trigger failed....

  • RE: How to fix Logon trigger issue

    Please look in the SQL error log and see what error messages were logged there from that login trigger.

  • RE: How to fix Logon trigger issue

    Still need...

    GilaMonster (9/5/2013)


    Look in the SQL error log. iirc, errors that occur in a login trigger's execution are logged to the error log. Check what's there.

    As for permissions, unless you...

  • RE: How to fix Logon trigger issue

    Look in the SQL error log. iirc, errors that occur in a login trigger's execution are logged to the error log. Check what's there.

    What's the schema of that table?

    What database...

  • RE: Clustered indexes

    Root page full, root page splits into two (old root page and newly added page). Cannot be two root pages, to another level is added above with a single page,...

  • RE: Upgrading from SQL 2008 R2 to SQL 2012 R2

    btw, there isn't a SQL Server 2012 R2. There's only SQL Server 2012.

  • RE: Difference Between Restore And Attach

    Attach is not the only way to move a database physically and restore doesn't modify databases (doesn't create them technically, the database was created previously if a backup exists)

  • RE: Logical Backup Maintenance Plan

    btw (because I'm sure someone would bring it up sooner or later)...

    MySQL has this kind of thing 'built in', because that's how MySQL does backups (or did last time I...

  • RE: Difference Between Restore And Attach

    sqlnaive (9/5/2013)


    "Attach is used to move a database physically and restore is used to create/modify database as per requirement based on backups"

    If you like. It's not true though.

  • RE: Logical Backup Maintenance Plan

    Many of the 3rd party backup tools allow you to restore individual objects from a normal backup. If that's an option, it might be worth looking into.

  • RE: DTA

    If you must use DTA, don't run it against production, don't set it to automatically implement recommendations and don't set it to remove indexes.

  • RE: Difference Between Restore And Attach

    Before you attach, there is no database. Just files in the file system. So no, that's not correct.

  • RE: Project Plan

    What information?

    How to do it? (you should know that)

    Reasons to do it?

    Something else?

    A project plan is a list of tasks and times to complete a defined project. No project,...

  • RE: Clustered indexes

    No such thing as a new leaf level. Levels are created when the root needs to split and a new root added above that.

  • RE: It's not you; it's us

    patrickmcginnis59 10839 (9/4/2013)


    Easily marked doesn't seem to be necessarily an impossible barrier. .... for that matter I'm sure they know how to mark a test.

    The lab...

Viewing 15 posts - 11,776 through 11,790 (of 49,562 total)