SharePoint etc.

This post will start a series of useful MS SQL Server scripts. Here's the one to display all tables and related columns that were created in the certain database: /* Begin */ SELECT  a.[TABLE_NAME], c.COLUMN_NAME FROM ( SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_TYPE = 'BASE TABLE') ) a INNER JOIN ( SELECT s.[name] as COLUMN_NAME, tt.name as TABLE_NAME FROM syscolumns s INNER JOIN (SELECT * FROM sysobjects WHERE type = 'U') tt ON tt.id = s.id ) c ON c.TABLE_NAME = a.TABLE_NAME ORDER BY a.TABLE_NAME /* End */ The following script will display just table names: /* Begin */ SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_TYPE = 'BASE TABLE') /* End */ Enjoy! :)

We are currently doing a lot of SharePoint integration and here's the good article I found explaining different authentication types for BCS (BDC): Authenticating to Your External System

We have launched a Japanese version of the Wylde Solutions Web Site - http://wyldesolutions.com/ja-jp 日本語がすこし分かります（＾＾）

We have done some good Web site design for ourselves at least. Now we have better look, more information for SharePoint lovers and more fun and interesting stuff. It's all here at http://wyldesolutions.com   Come to visit us online and in person. :)

You can get an error when trying to browse your SharePoint 2010 Foundation site on iPhone or Safari 5.0 browser. The symptoms: when you navigate to your Web site using its URL as http://mightysharepointsite.com or something you will get the following very descriptive error " Unexpected error - Correlation ID: 1abc234d-ab5c-6789-012a-a1b2c34de5fg Date and time: 03/08/2010 12:54:09 PM ". This error actually means: " System.ArgumentException: Item does not exist. It may have been deleted by another user.    at Microsoft.SharePoint.SPList.GetItemById(String strId, Int32 id, String strRootFolder, Boolean cacheRowsetAndId, String strViewFields, Boolean bDatesInUtc) at Microsoft.SharePoint.SPList.GetItemByIdSelectedFields(Int32 id,    String[] fields) at Microsoft.SharePoint.SPWeb.GetListItem(String strUrl, Boolean bFields, String[] fields)     at Microsoft.SharePoint.Utilities.SPMobileUtility.GetMobileFileUrl(String absolutePath, SPWeb we...

Initially I published an article Working with Managed Metadata in SharePoint 2010 here I want to illustrate some core functionality that is available when you want to manage Managed Metadata. In the Site Settings select "Term store management" item: Then select the term set you would like to manage. In my scenario I want to create a term set to store Document Categories. For example I have two categories: Accounting, Technical. So first I select a metadata group that you want to update and select "New Term Set" command: I call it Document Categories and Save it. Then I select this new term set and choose "Create Term" command: To create "Accounting" term: Then create as many terms as I want to get Accounting and Technical as I wanted: You can also do other command with your terms - Copy, Reuse, Merge, Deprecate, Move, Delete: After that I add Managed Metadata to my content type that I use for documents, select Document Categ...

Last week I worked 2.5 days doing SharePoint 2010 using Ubuntu 10.04 installed on my 6 yo laptop. Laptop: Samsung P28, Intel Celeron M, 1Gb RAM, 40Gb HDD, WiFi network adapter. Browser: Mozilla Firefox for Ubuntu canonical 1.0 Tasks I was able to do in regard to SharePoint implementation: - Document management. Creating documents using OpenOffice then uploading them into SharePoint via browser. - Management of custom lists, content types, site columns, views etc. All site settings available from Web browser UI. - Forms Authentication and Search set up. I used rdesktop to connect remotely to the SharePoint Web and Application server. Positive: - I have got most of the new features of user experience: ribbon, menus, styles etc. - If I don't need custom Web applications development for SharePoint or SharePoint Designer work on my laptop or other client machine I can use Open Source and free software easily. Anyway Visual Studio and SharePoint Designer could be installed st...