Browse by Tags

listing all the views or tables of a database
Sunday, May 17, 2009 1:32 PM
Handy quick sql command guide from Marcus Oh on finding tables/views, again keeping here so I can find it if ever needed. http://marcusoh.blogspot.com/2009/05/listing-all-views-or-tables-of-database.html Read More...
by Rickym61 | with no comments
Filed under: , , ,
SQL Pretty Printer: beautify the messy sql code instantly!
Saturday, May 16, 2009 11:41 PM
At MMS 2009, during "SQL Performance Tips for SMS and ConfigMgr Reporting Gurus" session by Brian Mason and Steve Thompson, this neat tool was featured and bought to the worlds attention (or those that never knew about it). This tool will even make John Nelson aka #2 happy so he doesnt have to see any ugly formatted SQL code (I will update the exact... Read More...
by Rickym61 | with no comments
Filed under: ,
sms query/report for spyware?
Monday, August 25, 2008 5:09 PM
This question seems to pop up on the list quite frequently, so to save time, here it is. It was originally posted to the list by Mark Mears, so credit goes to him, attached is the sql and sample of what results you may get again from Mark Mears SQL select all RSYS.Name0 AS 'Computer', RSYS.User_Name0 As 'Last User ID', SF.FileName As 'File... Read More...
by Rickym61 | 1 comment(s)
Filed under: , ,