Forum Replies Created

Viewing 15 posts - 10,741 through 10,755 (of 19,560 total)

  • RE: Need help with SQL Browser and Non-Std Port for Default Instance

    K. Odd

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 11:41 am

    #1303791

  • RE: script for security

    For such an action as you describe - cursors are somewhat commonplace. I would be careful about using msforeachdb though due to it's limitations (depends on the size of...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 11:38 am

    #1303786

  • RE: Neested Trans

    Quick note, if you read that article by Paul Randal that I posted - he demonstrates the save transaction aspect as well. You will also see that even using...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 11:35 am

    #1303783

  • RE: Neested Trans

    It doesn't work that way in SQL Server. nested transactions are a myth in SQL Server.

    Check out this reference:

    http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(2630)-nested-transactions-are-real.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 11:34 am

    #1303782

  • RE: Port number for SQL server service status

    douglas.strough (3/25/2011)

    We use VM templates for our SQL servers, so all servers are set up identical (all 78 that I manage). All are configured with default SQL configurations regarding...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 11:24 am

    #1303776

  • RE: Port number for SQL server service status

    Try this (even though you are Dom. Adm.)

    Use subinacl to grant the SQL DBAs group access to query service state on the MSSQLSERVER and SQLSERVERAGENT services

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 11:21 am

    #1303774

  • RE: Port number for SQL server service status

    do you see the status indicator display properly when on the server itself (rather than using ssms from your desktop)?

    I have to find some notes on it, but am certain...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 11:15 am

    #1303769

  • RE: Port number for SQL server service status

    The status indicator will be affected by permissions. The user making the connection needs to have adequate permissions on the Server. Are you able to remote to the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 11:09 am

    #1303766

  • RE: Need help with SQL Browser and Non-Std Port for Default Instance

    Do you have windows firewall on your client machine (the one that can't connect)?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 10:36 am

    #1303733

  • RE: Port number for SQL server service status

    Lowell (3/25/2011)

    i thought avoiding the use of 1433 was to avoid brute force attacks to discover passwords....script kiddies or worse.

    That is one of the benefits - extra layer of defense.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 10:34 am

    #1303731

  • RE: Port number for SQL server service status

    UMG Developer (3/25/2011)

    CirquedeSQLeil (3/24/2011)

    TCP 1433 should be changed in most cases to a different port number. This port can be changed but whichever port you decide on for the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 10:31 am

    #1303727

  • RE: Today's Random Word!

    crookj (3/25/2011)

    WOTD - Tired

    Recovering for a 13 hours drive - 1 day break - and another 13 hour drive back. (Speaking of back - PAIN!)

    Joe

    Not FUN!!

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 10:25 am

    #1303723

  • RE: Are the posted questions getting worse?

    GilaMonster (3/25/2011)

    WayneS (3/25/2011)

    Need an app that adds an "unused" folder to your system, takes a screen shot of the desktop, moves all icons to the unused folder, and replaces the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 10:14 am

    #1303718

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (3/25/2011)

    Fal (3/25/2011)

    I just popped along to the Guiness World Records website to see if we could lodge The Thread under a Longest Web Thread category or similar. ...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 10:12 am

    #1303716

  • RE: Are the posted questions getting worse?

    WayneS (3/25/2011)

    Congrats Gail on 25000! (And I think that this is the first major milestone on The Thread reached by a non-US Threadizen! Congrats again!)

    Edit: Added image. Thanks Gianluca for...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    March 25, 2011 at 10:10 am

    #1303714

Viewing 15 posts - 10,741 through 10,755 (of 19,560 total)