Database diagram support objects cannot be installed because this database does not have a valid owner Error

When generating the DB diagram in SQL server if we get the error "Database diagram support objects cannot be installed because this database does not have a valid owner" then we need to run the following command in SQL Server Management studio.


EXEC sp_dbcmptlevel 'YourdbName', '90';
go
ALTER AUTHORIZATION ON DATABASE:: YourdbName TO "domain\username"
go
use YourdbName
go
EXECUTE AS USER = N'dbo' REVERT
go

Cannot create database 'DevelopmentStorageDb20110816' in Storage Emulator Azure SDK

Please refer the following link.
http://www.britishdeveloper.co.uk/2011/11/cannot-create-database.html

Prevent inserting overlapping date ranges using a SQL trigger

select *
  from testdatetrigger t
   join inserted i
   on ((i.ValidTo >= t.ValidFrom) and (i.ValidFrom <= t.ValidTo))
  Where not (i.ValidTo=t.Validto and i.ValidFrom=t.ValidFrom)

This can be applied to the numbers as well.

Please refer the link

http://stackoverflow.com/questions/4023160/prevent-inserting-overlapping-date-ranges-using-a-sql-trigger