If you are using snapshots be aware that running sp_helpdb reports wrong files. Let's take a look by running some code

First create a test database

Catching the completion of a visual state change in Silverlight 3

A question was posted in our SQL Server programming forum today. A person had this stored procedure

Some bugs just don’t seem to be the trouble to fix.

I had this unusual problem with a treeview (the one that can be found at System.Windows.Forms.TreeView) and disappearing icons.

Just look at this.

You can see that there is nothing wrong with the icons or the imagelist because the button just above the treeview uses an icon from the same imagelist as the treeview.

Now this seems to be a known bug. Just look at this post...

FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key and there is a single row as the update source in SQL Server 2008

In Microsoft SQL Server 2008, a foreign key constraint may not be enforced when the following conditions are true:

• A MERGE statement is issued.

• The target column of the update has a nonclustered unique index.

Microsoft has created the first Hotfix for SQL Server 2008 which will fix this issue.

You can read more a...