SQL Server Performance Forum – Threads Archive
OSQL Scripts to know SQLServices detail
Any sql command to know ( since how long sqlservices are up and running ) ?since i m cycling the errorlog often it’s difficult to see from the error log. For which i’m planning to write a script (osql)which i can execute from DOS command prompt. Any link how to write OSQL Scripts which i can execute from dos command prompt window ?
Hi,<br />t-sql remain same as isql but can be executed from osql<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Thanks hemant for info… guy explaoining my question in detail "any command which can be executed from QA / cmd prompt which can give me the output – sql servers services are running since xx/xx/xxxx xx<img src=’/community/emoticons/emotion-12.gif’ alt=’:x’ />x<img src=’/community/emoticons/emotion-12.gif’ alt=’:x’ />x (time)"?<br /><br />Example -<br /><br />Box name (XXXXXX)<br /><br />SQL Server : running since 40 days 30 minutes 25seconds<br />SQL Server Agent : running since 30 days 20 minutes 20 seconds <br />.<br />if possible msdtc<br /><br /><br /><br />
Hi,<br />refer below thread :<br /<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11640>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11640</a><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
]]>