First get all xtype ‘U’ (TABLES) in database: USE [database]SELECT * FROM sysobjects WHERE type = ‘U’ ‘P’ = Stored Procedures‘V’ = Views Next select all columns that matches: For a list of TABLES, COLUMNS and TRIGGERS… run this query that took mealmost *5 minutes* to write! SELECT O.[NAME] AS ‘TABLE’, C.[NAME] AS ‘COLUMN’, C.[ID] [...]
using : ubuntu minimal boot using: Unetinst using bootable USB Links: https://help.ubuntu.com/community/Installation/FromUSBStick http://www.lifehacker.com.au/2009/05/install-a-minimal-ubuntu-desktop/ https://help.ubuntu.com/community/Installation/MinimalCD http://www.howtogeek.com/howto/linux/create-a-bootable-ubuntu-usb-flash-drive-the-easy-way/ http://sourceforge.net/projects/unetbootin/
Using: SPList Using KWiz Scenario:Several subsites having each their department calendar.One main calendar that includes items from deepartment calendars. Main calendar running several calendars, like KWiz. First setup sub calendars to allow tagging for frontpage calendar:http://stsadm.blogspot.com/2008/11/my-new-powershell-cmdlets-for.html install the extention add a boolean column that indicates if it should be on main calendar.: PS C:\DEVELOP> $list [...]
If you, like me, used to copy your files to your Linux server just to get access to a decent Diff utility, despair no more. WinMerge is a must have tool in your belt: http://sourceforge.net/projects/winmerge/ Nicely color coded and it allows [ screens ]
