[sp_temp] AS BEGIN SET NOCOUNT ON; SELECT * from dbo.temp ... in SQL Server 2016 and above version To drop a database object in SQL Server 2016 and above we need to execute a simple statement. Now we ...