Post reply

SQL Start up Script

  • September 24, 2012 at 9:40 pm

    #282041

    Comments posted to this topic are about the item SQL Start up Script

  • September 25, 2012 at 4:20 am

    #1541752

    Fine and neat script, but I have a question.

    Did you put this an all 100+ SQL servers?

  • September 25, 2012 at 7:04 am

    #1541839

    Excellent script. However, I don't understand the reason for the test in:

    IF CAST(LEFT(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR),1) AS INT)>8

    I understand that the ComputerNamePhysicalNetBIOS property did not exist prior tp SQL 2000 but your test would return a 1 for SQL 2008.

    I assumed your code was for SQL 2005 or higher since you query sys.databases and use sp_send_dbmail.

    Thanks again for a very usefull script.

    Lee

  • September 25, 2012 at 10:24 am

    #1541979

    Yes I did. With so many servers it became a requirement on all new server builds. It was a small part of a SQL monitoring system.

    It was setup so that a group of user DBA's would get a text message whenever a server restarted, and each server could be configured to send emails/text alerts to different users depending on who the business owner was.

  • May 9, 2016 at 1:30 pm

    #1877605

    Thanks for the script.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy