SQL

SQL server could not start cannot find object or property (0×80092004) Recently I got an error in my  colleague's system  that he cou...

If a column has a default value it means there is a constraint on that column setting it the default value.  The alter command will give yo...

Today I was trying to restore a database backup using SSMS. The backup was sent by my friend through FTP. But SSMS raised the following err...

Today I got one requirement from my collegue to delete all records from all Tables in the database. To do this we had to use either Delete ...

From version 7.5 (Mango) WP7 runs a version of SQL Server CE which is all setup waiting for your applications to make use of it. The good n...