We have seen recyle bin in Oracle 10g and it is very good feature in Oracle database but in case of SQL server is there any tool or store proc by which we can rollback our data or dropped object in database.(Default)
We have experience in sql server with Begin transaction , and whenever we use this command with update or delete statement then we can rollback deleted or changed data if required.
There is no 'recycle bin' built in to SQL Server, per say, other than your transaction log backups. RedGate has a tool called 'Virtual Restore' that would make this process easier, but it still requires backups. There may some other third party
tool you could use.