SQL to SMS Syntax Help

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

SQL to SMS Syntax Help

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> SQL to SMS Syntax Help

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL to SMS Syntax Help - 7/30/2008 4:48:40 PM

cpatrick891

Posts: 15
Score: 0
Joined: 9/18/2007
Status: offline

I connected to my SMS 2003 Database with SSMS 2005. I put together a query an wish to now use it in SMS to create a collection. However, I get syntax errors when I try to paste it into the a query window in SMS. Works fine in SQL 2005 ... hates me in SMS. I have not done as much query writing in SMS as I would like to and am now starting to do more of it. Is there a resource to help me with this or some guidlines that some of you more experienced administrators can throw my way?

Post #: 1

RE: SQL to SMS Syntax Help - 7/31/2008 4:04:56 AM 1 votes

jschoone

Posts: 359
Score: 25
Joined: 4/10/2004
From: Norway
Status: offline

Hi!

Since the Queries (and Collections based on them) use WQL in stead of T-SQL you have to rewrite your SQL queries. WQL is a very limited subset of SQL used to query the WMI objects/names.

Reports though are SQL queries and you can try to put your SQL-statement in a report but it will not help to create a collection.

The resource Microsoft provides on it is the SDK!

An article about WQL/SQL on this forum: http://www.myitforum.com/forums/m.asp?m=169323

Jan

< Message edited by jschoone -- 7/31/2008 4:12:30 AM >

(in reply to cpatrick891)

Post #: 2

RE: SQL to SMS Syntax Help - 7/31/2008 10:08:07 AM

cpatrick891

Posts: 15
Score: 0
Joined: 9/18/2007
Status: offline

Jan,

You are the man. This is exactly what I needed. Thank you.