I am using SQL Server 2005 and I having problems with stored procedures.
Whenever I create an SP and save it, it saves it here "My Documents" --> "SQL Server Management Studio" --> "Projects".
The problem: It does not appear in Microsoft SQL Server Management Studio in this folder "Programmability" --> "Stored Procedures" for the database that I'm working with. I always have to connect to the server remotely to create my SPs. Only then does it appear in the "Stored Procedures" folder.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed