Forum Replies Created

Viewing 15 posts - 826 through 840 (of 1,315 total)

  • RE: "invalid class string error" when building diagrams

    I'm pretty sure I remember reading that client tools (EM and QA) must be reinstalled on all clients for SP4.  I don't remember the issues, but this might be one...

  • RE: Recovery model options

    You do not have to restart SQL after ALTER DATABASE.

    Have you looked at replication or log shipping?  Unless a large percentage of the production database has been modified from one...

  • RE: Outer Join Mystery

    You might think "there should be no problem with what to join together" because you put parentheses around the derived table, but the query optimizer has its own agenda sometimes. ...

  • RE: SSMS doesn''''t recognize db_ddladmin rights

    After some experimentation I found that

    grant

    VIEW DEFINITION on SCHEMA::dbo to ddladmin_user

  • RE: Outer Join Mystery

    The use of the old-style syntax promoted the entire WHERE clause to the ON clause.  You get the same results as the "wrong" query if you used "LEFT JOIN ......

  • RE: Integer vs. Decimal

    Integers will perform better than decimal because a CPU can't do arithmetic on decimal values.  They have to be converted to a scaled integer representation to be used in expressions,...

  • RE: SIMPLE recovery mode not truncating tranlog

    Was this database (or an ancestor) ever replicated?  A database that was set up for replication would exibit the same symptoms (log not truncating) if the replication agents were stopped but the...

  • RE: CHAR(13) Prints an Invisible Character

    You'll have better luck in general with linefeed (CHAR(10)) than carriage return (CHAR(13)). 

    As pointed out already, CONVERT(CHAR(1), 0x0A) is just a long-winded way of saying CHAR(10).

  • RE: Moving Logins and Users

    If you only needed a one-time fix, then you're in good shape.

    If you have to move databases between servers more often, say between test and production, it helps if you...

  • RE: SIMPLE recovery mode not truncating tranlog

    You might try examining the log for clues with undocumented DBCC commands:

    DBCC

    LOG ( '<database>' |

  • RE: SIMPLE recovery mode not truncating tranlog

    I double-checked in BOL just to make sure I was correct.  A CHECKPOINT in simple recovery mode truncates the logical log file (marks virtual log segments as reusable) but doesn't...

  • RE: SIMPLE recovery mode not truncating tranlog

    Simple recovery mode does not cause the tran log file to shrink.  You could set the autoshrink option for the database to make that happen (not a best practice in...

  • RE: ReApplying LOGINS, USERS, and ROLES

    That is correct, you just need to make sure the logins are recreated with the correct SID in the master database.  Roles and permissions for the users will be restored with...

  • RE: Question of the Day for 25 Apr 2006

    The EXECUTE AS statement has a syntax error and does not execute, so the context is never changed to Bob.

    The correct answer is D, but it may not be the...

  • RE: Helpdesk to ''''Kill'''' users

    Don't use the "sp_" prefix on user stored procedures, especially when giving advice to newbies.  It might be years before he realizes what a cruel joke you've played on him.

Viewing 15 posts - 826 through 840 (of 1,315 total)