Abstract:The development of a large number of stored procedure, function, and trigger scripts for the SQL SERVER data in the regional automatic weather station realizes the operation and the automatic data analysis and storage of daily, monthly and yearly statistics. Through accessing and making a comprehensive analysis of the information in central database, the sub-system can monitor and give SMS alarm in running status. It also provides services like query and download hourly, daily, monthly and yearly information. This system is a solution to such problems: failure to monitor equipment, to make data analysis, to download and access information.