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...

    November 17, 2015 at 1:37 am

    #1840213

  • 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...

    November 9, 2015 at 8:41 am

    #1838581

  • 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...

    March 24, 2015 at 5:07 am

    #1785913

  • 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...

    March 24, 2015 at 4:17 am

    #1785904

  • 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...

    March 11, 2015 at 3:13 am

    #1783165

  • 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...

    March 10, 2015 at 1:38 pm

    #1783072

  • 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...

    March 10, 2015 at 12:07 pm

    #1783046

  • 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...

    March 4, 2015 at 1:43 pm

    #1781758

  • 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!

    February 24, 2015 at 8:58 am

    #1779620

  • 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...

    February 20, 2015 at 8:43 am

    #1778969

  • 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

    February 16, 2015 at 9:00 am

    #1777847

  • 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.

    February 3, 2015 at 4:12 am

    #1774979

  • 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...

    January 30, 2015 at 3:45 am

    #1774287

  • 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...

    January 29, 2015 at 1:55 am

    #1773910

  • 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...

    December 23, 2014 at 7:56 am

    #1766205

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