Linked Servers????

5 pts.
Enterprise Manager
Linked servers
Microsoft Windows Server 2003
Windows Server
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. Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check out a product called Spiceworks….works great for me and includes a help desk….

From Ritchie1:
the linked server idea should required the least amount of work on your part if the data is already stored in a sql server database. There is no need to write an application to parse it etc then put back into sql server. In your sql server (if 2005) – server object / linked servers / add – (its similar in 2000 but its a while since I used it). You will need a username with permission to the original database.
Once linked server added – to get data simply query it with the servername as first part in From statement, e.g
Select column1 from ManagersServer.dbo.Tablename where …..
You could use a SELECT INTO statement to insert it into your own database. Put it inside a task and you have automatic import from one sql server to another.
If you can not get rights to the other server – an export csv / txt file on his SQL Server to a shared folder on the network and and an import running on your SQL Server should be the next best thing

Discuss This Question: 1  Reply

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Pressler2904
    I'm not a SQL admin, so I can't specifically answer your question, but I am familiar with Spiceworks. I'm not sure that it will be able to do what you are looking for, especially since the SMS server has a much more powerful system inventory tool than the inventory module Spiceworks uses. I would agree that VB or some similar scripting tool should be able to grab the output returned from your SMS query, parse it and pass it to your other database in usable format. I've seen it done, used similar scripts myself, but am almost totally clueless regarding how to write one....
    2,190 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: