December 2007 - Posts

2
Comments

SMS 2003 - Selecting from v_Add_Remove_Programs still slow, even after applying 939872 by jnelson

!!!! UPDATE !!!! WHEN YOU'RE DONE, THIS ARTICLE HAS BEEN UPDATED --> HERE PROBLEM I don't know if this is a function of the massive size of...
2
Comments

SMS - #2's #1 suggestion - Learn to read/write WQL/SQL by hand by jnelson

My #1 suggestion after years of working with SMS/SQL/WQL and then coaching/mentoring/training people is that it REEEALLLY pays to know how to read/write...
0
Comments

SMS 2003 - ITMU Patch Data - Service Packs and other low severity patches show up multiple times by jnelson

SYMPTOMS You're trying to determine your patch compliance for the latest round of Microsoft patches, but you notice that if you include low severity...
0
Comments

Update - Rewritten for SQL 2000 - SMS 2003 - Getting information about advertisements when package or ad has been deleted by jnelson

Apparently there are enough people that still have SQL 2000 that I get hounded with questions whenever I post something that only works on SQL 2005, which...
0
Comments

SQL 101 - What's the difference between tables and views? (or views and tables) by jnelson

A common theme I seem to be getting from people in the SMS/SCCM forums is possibly a misunderstanding of the difference between tables and views. I don't...
Filed under: , , ,
1
Comments

SMS 2003 - Getting information about advertisements when package or ad has been deleted by jnelson

THE PROBLEM There are canned reports that come with SMS that let you see advertisements and the machines that were targeted and the package that was sent...
0
Comments

SMS 2003 - SQL Error: (SMS Message ID 620, SQL Message 2801) The definition of object 'sp_GetPublicKeySMSUID' has changed since it was compiled... by jnelson

PROBLEM Recently, we started seeing a TON of errors in SMS_DISCOVERY_DATA_MANAGER, SMS_INVENTORY_DATA_LOADER and SMS_SOFTWARE_INVENTORY_PROCESSOR (click...
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems