Plz help me to find error in this stored procedure

There is no error in that stored procedure, however if you run it more than once you will get a runtime error

Quote:

Msg 2714, Level 16, State 6, Procedure PackageMaster, Line 3
There is already an object named 'tbl_PackageMaster' in the database.

You need to see if the table already exists first .. e.g. if you want to drop it if it already exists you could use

create PROCEDURE PackageMaster
AS
BEGIN
	IF (EXISTS (SELECT * 
                 FROM INFORMATION_SCHEMA.TABLES 
                 WHERE -- TABLE_SCHEMA = 'YourSchema' and 
					TABLE_NAME = 'tbl_PackageMaster'))
	DROP TABLE tbl_PackageMaster
	
	CREATE TABLE tbl_PackageMaster
	(
	  Pkg_ID  INT PRIMARY KEY NOT NULL, 
	  Pkg_Internal_ID INT IDENTITY(1,1),
	  Pkg_Name NVARCHAR(MAX),
	  Pkg_description VARCHAR(MAX),
	  Pkg_Image1 VARCHAR(MAX),
	  Pkg_Adv_Book_Days INT,
	  Pkg_time_from DATETIME,
	  Pkg_time_to DATETIME,
	  Pkg_basic_guest_no INT,
	  Pkg_hours_included INT,
	  Pkg_Distance_Covered INT
 
	)
END

or if you only want to create it if it doesn't exist you could use

CREATE PROCEDURE PackageMaster
AS
BEGIN
	IF (NOT EXISTS (SELECT * 
                 FROM INFORMATION_SCHEMA.TABLES 
                 WHERE -- TABLE_SCHEMA = 'YourSchema' and 
					TABLE_NAME = 'tbl_PackageMaster'))
	CREATE TABLE tbl_PackageMaster
	(
	  Pkg_ID  INT PRIMARY KEY NOT NULL, 
	  Pkg_Internal_ID INT IDENTITY(1,1),
	  Pkg_Name NVARCHAR(MAX),
	  Pkg_description VARCHAR(MAX),
	  Pkg_Image1 VARCHAR(MAX),
	  Pkg_Adv_Book_Days INT,
	  Pkg_time_from DATETIME,
	  Pkg_time_to DATETIME,
	  Pkg_basic_guest_no INT,
	  Pkg_hours_included INT,
	  Pkg_Distance_Covered INT
 
	)
END