How to List all tables that don't have clustered index

How to visualize the unused space for heap tables (with no clustered index)

An error occurred that requires the BizTalk service to terminate. The most common causes are the following:
 1) An unexpected out of memory error.
 2) An inability to connect or a loss of connectivity to one of the BizTalk databases.
 The service will shutdown and auto-restart in 1 minute. If the problematic database remains unavailable, this cycle will repeat.

 Error message: Exception has been thrown by the target of an  invocation.
 Error source: mscorlib

 BizTalk host name: BizTalkPricingApplication
 Windows service name: BTSSvc$BizTalkPricingApplication


How do we use Business Data Catalog?

Well to keep it very simple, you have an example file below that you need to download or to rewrite. The file contains a basic query to the AdventureWorks database. However you need to change some variables in order to adapt the file to your context (change all the "my" starting  word thing)

Then go to Sharepoint Central Administration, in the left menu, click on SharedServices1, then click on the Import application definition. Choose your file location, then for the moment leave the other options as they are. 

And here you are done, the BDC is imported, and you could youse it in any BDC Web Part

I found an interesting article in the internet that responds to the question :

Why the hell my Filtered view in the document library in Sharepoint doesn't filter when I specify Approved, or Complete, or whatever.

In fact the solution is simple : 

When I tried to set up the filter, setting the [Workflow Status] field to Approved, the filter returned no results. As it turns out, workflow status is stored as a numeric value.


The values are as follows:
In Progress - 2


Complete - 5


Canceled - 15


Approved - 16

Rejected - 17


I already experienced several times the error : "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" Could any one explain to me to what this is related?

This time there was no impact, but it could have in the future?

For information purposes only, we found what was going wrong.

The BizTalk Server is not the same as the SQL Server A user belonging to the Active Directory was used by BizTalk Server to access SQL Server

The issue in our case was related to the patch of the Active Directory that made this error.

Some weeks ago I was faced with a problem, as entry, I had a flatfile schema with positional fields. Before processing this file I needed to validate that every field is ok.

I had a problem with dates, since if I received let's say 10 space characters (representing and empty date) then the schema was not valid. So how the hell could we have resolved the problem? How could we say to BizTalk that for space characters on the Date it is ok, and it should go forward?

Here we needed BizTalk Server to stop processing any wrong file, we did not want BizTalk to continue any further. 

Every solution must be on the schema, solutions in other parts of BizTalk (mapping, custom pipeline, orchestration, ...etc.) was not a state of the art solution.

So What I did was simple :

  • In the schema you specify that the padding character is spaces
Padding Schema BizTalk
  • you specify that the empty fields are authorized
Empty Nodes BizTalk Schema Properties

These two actions were enough and solved my problem


Microsoft Office Sharepoint Server 2007 est le nouveau produit phare de Microsoft. Cet outil permet de regrouper plusieurs fonctionnalités du système d'information de l'entreprise en un seul produit, il regroupe entre autres les fonctionnalités de Calendrier, Blog, Gestion des Réunion, Groupes de travail, Reporting...

MOSS 2007 permet le partage de l'information avec des outils natifs Microsoft 

I installed MOSS 2007 on my virtual PC. locally everything works find by using and typing the http://myserver/

However, when I try to access my virtual PC from the outside http://myipaddress:myport/ (which points to my VPC), every thing works fine except :

When I click on Documents (top bar), I see the http://myipaddress:myport/Docs  (on the task bar of ie), however the http gets redirected to http://myserver which of course doesn't exist in the outside of home network

This is wired, does MOSS have a hardcoded http addresses (including the name of the server) or does it work exclusively on relative http addresses?

Next when I click on site specifications of document, I could see that they are on http://myIPAddress/Documents/Forms/AllItems.aspx however I can see no myport specification

This is a case for Alternate Access mappings. sharePoint is doing just what it is designed to do. in order to access your site from a different URL, youneed to go into your Central Administration and create an Alternate Access mapping for the web application to map the myipaddress:myport to myserver.