Forum Replies Created

Viewing 15 posts - 16 through 30 (of 105 total)

  • RE: Making Deployments Simpler with Re-runnable Scripts

    Nice article Ed,

    However, the first example with the Stored Procedure, I'd like it more the other way around, CREATE if it does not exist and then ALTER. That way...

  • RE: Create Procedure

    g.britton (11/4/2015)


    Carlo Romagnano (11/4/2015)


    If I want to be pedant, the right answer is "All of the above".

    Because of lacking of batch separator "GO".

    If you run the script no procedure is...

  • RE: Detecting Replication

    raulggonzalez (3/24/2015)


    eric.notheisen (3/23/2015)


    Published in March 2015 -Needs closing

    Does it mean the article is no longer required?

    Hello again, I found this one http://www.sqlservercentral.com/articles/Replication/122402/ by yourself, so I guess...

  • RE: Detecting Replication

    eric.notheisen (3/23/2015)


    Published in March 2015 -Needs closing

    Does it mean the article is no longer required?

    I must have skipped this, because I didn't see published anything on that topic this...

  • RE: Reading Logs

    Hany Helmy (3/11/2015)


    raulggonzalez (3/10/2015)


    Sean Lange (3/10/2015)

    Thanx 4 sharing the script, but if u have a common SQL login that is being used by an application accessed by many users, then...

  • RE: Reading Logs

    Ed Wagner (3/10/2015)


    Sean Lange (3/10/2015)


    raulggonzalez (3/10/2015)


    Sean Lange (3/10/2015)


    I knew of the function to return the login for the current connection, but I thought it was like GETDATE() where you just...

  • RE: Reading Logs

    Sean Lange (3/10/2015)


    I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best of my knowledge...

  • RE: Database ownership and TRUSTWORTHY

    Ken Grissom-138180 (3/4/2015)


    Thanks for the information.

    But that raises a question for me.

    If we are not to use the TRUSTWORTHY with SA access what about the MSDB? Since Microsoft has...

  • RE: Drop Database

    RK Mandava (2/24/2015)


    good question,

    here is nice article about that..

    http://www.brentozar.com/archive/2015/02/dropping-offline-database-sql-server/

    +1

    read it too, so this was a piece of cake.

    Nice question!

  • RE: Who Truncated That Table & What Do I Do Now?

    SQLRNNR (6/5/2014)


    INCREDIBLEmouse (6/5/2014)


    I see the "myth" is busted for Full model.

    Is it still un-busted for the other models?

    Truncate is still a logged operation in the other models.

    The myth has been...

  • RE: Approximate Data types

    Koen Verbeeck (2/16/2015)


    Easy question, thanks.

    Some resources might be appreciated.

    BOL

    https://msdn.microsoft.com/en-GB/library/ms187752.aspx

  • RE: Detecting Replication

    I've run into this problem before, it'd be nice to get all the concepts together. If there's no much rush I can do it.

  • RE: Simple Selects

    Sean Pearce (1/30/2015)


    https://msdn.microsoft.com/en-us/library/ms179882.aspx

    SELECT £

    SELECT $

    SELECT ¥

    SELECT €

    SELECT ?

    SELECT ?

    SELECT ?

    SELECT ?

    SELECT ?

    That is exactly the point, money and smallmoney data types accept a number of currency symbols and it's good...

  • RE: Database ownership and TRUSTWORTHY

    h.tobisch (1/29/2015)


    this article is a rare example for what i expect of a well-written article.

    exposure at the beginning, conclusion, references, some reasonable reasoning in the main part.

    congratulations.

    Thanks!, Since this is...

  • RE: Lists

    DrKiller (12/23/2014)


    wow what a complex way of doing it.

    I'm usually just doing this 🙂

    DECLARE @tmpString VARCHAR(MAX)

    SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM Header

    SELECT @tmpString

    You opened Pandora's...

Viewing 15 posts - 16 through 30 (of 105 total)