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