Cannot insert the value null into column ‘diagram_id’, table dbo.sysdiagrams

When ever I copy the database from the production server to the development machine the database throws an error when updating a database diagram or creating a new database diagram. The error in question is The solution to this problem is rather simple go to dbo.sysdiagram table and set change the diagram_id default value to … Read more

AutoCompleteCustomSource – Specified Cast is Not Valid

There was a requirement to implement a textbox with a databound AutoComple feature. As the Autocomplete source was a database, I have to go for a custom DataSource. The main requirements for an auto-complete textbox (in this scenario) are: AutoCompleteMode is set to Suggest(or SuggestAppend). AutoCompleteSource is set to CustomSource AutoCompleteCustomSource is set AutoCompleteStringCollection. A … Read more

NTEXT vs NVARCHAR(MAX) in SQL 2005

I recently profiled a sproc that makes heavy use of the TSQL SUBSTRING function (hundreds of thousands of times) to see how it performs on a SQL 2005 database compared to a SQL 2000 database. Much to my surprise the SQL 2005 database performed worse…dramatically worse than SQL 2000. After much researching it turns out … Read more

Missing Items in Visual Studio 2005 Menu

I noticed some missing menu items in the VS2005 (like clean, rebuild, and many others) but i continued by using the commands from other locations; until I got stucked!  I wanted to export a form as a template but the Export was not available in the File menu. The details of my environment are: WIN … Read more