Following query will help to find field name available in any of the table in a database. SELECT * from INFORMATION_SCHEMA.COLUMNS  wher...

Select the database you want to filter the information about the row count and run following SQL Statement SELECT      T.NAME AS 'TA...

Solution: "The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value" with Entity Framew...

Create and Configure a Universal Data Link (.udl) File with Notepad. I just came across a way to test a data provider’s connection str...

The tail of the transaction log usually refers to the contents of the database's transaction log that has not been backed up.  Basicall...