If you would like to find out a Database restore, source and backup date you will need to execute the below script: SELECT [rs].[destination_database_name], [rs].[restore_date],……
SELECT ID FROM yourTable GROUP BY ID HAVING (COUNT(ID) > 1) In SQL 2005+ you can do the following and get all of the columns:……