Forum Replies Created

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

  • RE: Need Scripts

    J Livingston SQL (10/12/2013)


    ??....why the "shouting"?

    No, m=not shouting.. just went Wacko...:w00t:

    as i thought member 'motherstechbpo' provided me script.. but he rather posted his jobs and vacancy info 😀

  • RE: Need Scripts

    :w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:vv

    Thanks for the SCRIPT:w00t::w00t:

  • RE: Need Scripts

    I downloaded Brents script.. its huge & didnget which to use from them..

    can anyone help me with scripts one by one for below need 🙁

    1) Script to Identify what Indexes...

  • RE: Need Scripts

    Hi Beatrix, i have limited access to Links out .. Would appreciate if you share any of such if you have downloded 🙁

  • RE: Need Scripts

    Beatrix Kiddo (10/10/2013)


    There's a good free pdf book here called SQL Server Maintenance Plans[/url], and it has some nice sections on indexes, especially pages 106 onwards.

    It ask's for payment :w00t:...

  • RE: Help

    Thanks Rookie.. It worked 🙂

  • RE: Help

    Its Windows NT 6.1

  • RE: Help

    This settings needs to be done on Destinations server??

    Below is my scenario..

    Source server - AAA

    Destination server - BBB

    Linked server configured on AAA

    & we want to run a stored procedure in...

  • RE: Help

    I went to the specified path u said..

    Bu in security tab i can only see

    Enable XA Transactions :w00t:

  • RE: Restore Information SQL DB

    Thank you hansi..

    Please check my new post.. need some more scripts on urgent basis... if u can help 🙂

  • RE: Finding Server Name

    Thanks Sean & Gail for suggestions & query.. it worked..

    We caught the Table where we need to do the change 🙂

    Appreciate your prompt replies.. god bless u all..

  • RE: Finding Server Name

    Sean Lange (10/9/2013)


    OnlyOneRJ (10/9/2013)


    We have

    Server name- TESTXXAB

    Database name - TEST_USER

    This DB have many Tables

    Now we have to write a query which will search the data in the tables which...

  • RE: Require Template !!!

    Lolzz Andrew... Thanks Gail....

    Now they have got a DBA who knows about Backup/restore, logins, user access, Maintenenace tasks etc.. but no knowledge of performance tunning...

    they are from different department so...

  • RE: Require Template !!!

    Right Andrew.. but they will not do so.. they have asked a developer to perform this task:-D

  • RE: Access rights

    SQLJim88 (9/19/2013)


    You can run SP_who2 with "View Server State" permissions.

    grant ALTER ANY CONNECTION to USER, will allow you to kill user sessions.

    I have created a Group Named - "Dev_Team"

    What will...

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