Forum Replies Created

Viewing 15 posts - 3,316 through 3,330 (of 3,347 total)

  • RE: The DBA Whoops

    Hi Steve,

    Great editorial, and some sound advice (both in the editorial and in this thread).

    Your error reminded me of an error my former boss made many years ago (back in...

  • RE: Question of the Day for 30 May 2006

    Hi Steve,

    >>The quote you mention specifically says "does not raise system errors". I'm not sure where that is direct contradition<<

    The contradiction is in "or report errors that are not severe"....

  • RE: Question of the Day for 30 May 2006

    I'm sorry, but the answer is just wrong. Here's an exerpt from the Books Online quote that was linked to in the answer:

    0-9

    Informational messages that return...

  • RE: Question of the Day for 25 May 2006

    Apart from the syntax error (which I missed - shame on me!), there's also insufficient information to assess what the answer would be if the syntax is corrected.

    What if Andy doesn't...

  • RE: Question of the Day for 15 May 2006

    Hi wangkhar,

    My post was intended only as an FYI, as an addition to the information given in the "official" answer to the post. I didn't intend to criticise the question.

    I...

  • RE: Question of the Day for 15 May 2006

    Hi all,

    Though Ctrl-Shift-C won't work in Management Studio "out of the box", it IS possible to restore this keyboard shortcut for those who have QA keys preprogrammed in their fingers:

    Menu...

  • RE: Who Has The Monitor?

    Unfortunately I can't see if that affects the results as my laptop's not capable of generating an execution plan for the final query!  That's a first for me!

     
    Hi Glenn,
     
    I...
  • RE: Who Has The Monitor?

    I'm surprised at the number of posts claiming that there is just one solution. Below are the four solutions that SQL Server returned on my query. As far as I...

  • RE: Who Has The Monitor?

    Hi SAM,

    I get the same error when I execute on SQL Server 2000. On SQL Server 2005, I do get a response.

    However, in all three or four solutions, Kevin uses...

  • RE: Who Has The Monitor?

    Hi Steve,

    Fortunately, I had kept my query window open over the day!

    With the clarification that first = leftmost (my first assumption) and the...

  • RE: Who Has The Monitor?

    Okay, so my assumptions were wrong.

    The green office was to the left of the white office." - is that directly to the left (adjacent) or somewhere...

  • RE: Who Has The Monitor?

    Hi Steve,

    Some clues allow more than one interpretation:

    "The green office was to the left of the white office." - is that directly to the left (adjacent) or somewhere to the...

  • RE: Question of the Day for 25 Apr 2006

    Thanks, Steve!

     

  • RE: Question of the Day for 25 Apr 2006

    Hi,

    I answered D, because I thought that this was a trick question. Turns out it was just a typo.

    The correct syntax for EXECUTE AS is: EXECUTE AS USER = 'Bob'...

  • RE: Question of the Day for 13 Mar 2006

    Hi SQLBill,

    True - but it also says:

    If the message contains more than 400 characters, only the first 397 will be displayed and an ellipsis will be added...

Viewing 15 posts - 3,316 through 3,330 (of 3,347 total)