Hi everybody, I'm an IT student and i'm doing professional practices. A simple project was assigned to me.
This company uses SMS to collect information of all his PC's and stores this information in a MSSQL database. A manager checks this information and fills another database located in another server.
For example, in the SMS database checks the percentaje of computers with 512 mb ram or higher, and if this value is bigger than 80%, stores a number in the other database.
I want to do this automatically. The OS default in servers is Windows Server 2003 and MSSQL Enterprise Manager v. 8.00
I was thinking in using only linked Servers in MSSQL and advanced querys, but i don't know exactly how to do this, or if there are a better option to do this.
Somebody suggested me to use visual basic .NET but i'm not shure if that is a better idea.