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