--set parseonly on

select @@version
--Microsoft SQL Server 2005 - 9.00.5000.00 (X64)
--Dec 10 2010 10:38:40
--Copyright (c) 1988-2005 Microsoft Corporation
--Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)



use dba
go

create procedure mysp
as
begin

select getdate()
select * from mytablethatdoesnot exist

end