SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Monday, May 20, 2013
Open failed. Could not open file mdf for file number 2. OS error 5(Access denied)
›
Today my one client told me that their database could not access in yesterday, we try to use the database and got message error the da...
Monday, May 13, 2013
Swap data between columns
›
Sometime we may mistakenly insert data into a wrong column if we have two identical columns with same data type. To correct this we have to...
Monday, May 6, 2013
database last accessed date time
›
Sometime you may required to know the last accessed date and time of database.. Below query returns the lass accessed date and time of SQL...
Monday, April 29, 2013
Verifying Foreign Keys in MS SQL Server
›
Today I was checking one Demo database and surprised to see that foreign key columns contained some values which were not stored in the ref...
Tuesday, April 23, 2013
The database cannot be opened because it is version 706. This server supports version 661 and earlier
›
Today I was trying to Attach a database in SQL server 2008 R2. I got below error while attaching database: This is because the data...
‹
›
Home
View web version
