Hi Kelley

thx for reply. I can't use dbo level account bcoz user with this role can alter the table and I want developers to create Store Proc and use DML...

Hi

Thnaks for replay.Pls find the code below...

ALTER       PROCEDURE IOL_AccomodationSearchResults

 @lv_SessionID  varchar(50),

 @li_ProductXid  int,

 @li_BrochureXid  int,

 @li_HolidayXid  int,

 @li_ClientXid  int,

 @ld_FromDate  datetime,

 @ld_ToDate  datetime,

 @lv_HotelXid  varchar(1000),

 @li_HotelChainXid int,

 @li_SupplierXid  int, 

 @li_PropertyTypeXid int,

 @li_RatingXid  int,

 @lv_Location  varchar(20),

 @li_CountryXid  int,

 @li_CityXid  int,

 @li_CountyXid  int,

 @li_ZoneXid  int,

 @lv_HotelFacilities varchar(1000),

 @lv_RoomFacilities varchar(1000),

 @li_OfferTypeXid int,

 @lv_RoomConfiguratrion varchar(100),

 @lc_QBDataYN  char(1),

 @li_NoOfPax  tinyint,

 @li_CompanyXid  int,

 @li_LastEditByXid int

AS

DECLARE

 @li_StringPos  int,

 @li_NoOfAdult  tinyint,

 @li_NoOfChildren tinyint,

 @li_Age   tinyint,

 @li_DayWeek   tinyint,

 @li_CheckinDay  tinyint,

 @li_NoOfContracts tinyint,

 @li_RConfigDtlsXid tinyint,

 @li_ChildAgeFrom tinyint,

 @li_ChildAgeTo  tinyint,

 @li_MinimumStay  tinyint,

 @li_TempMinStay  tinyint,

 @li_PerWhatQty  tinyint,

 @li_Qty   int,

 @li_AdultChargeTypeXid int,

 @li_ChildChargeTypeXid int,

 @li_ExtraChildChargeTypeXid int,

 @li_ChargeTypeXid int,

 @li_MaxXid  int,

 @li_i   int,

 @li_Counter  int,

 @li_j   int,

 @li_Cnt   int,

 @li_k   int,

 @li_l   int,

 @li_RateXid  int,

 @li_CombinationRuleCnt int,

 @li_QuickBedSupplierXid int,

 @li_HotelXid  int,

 @li_OldHotelXid  int,

 @li_SHCDataDtlsXid int,

 @li_RoomTypeXid  int,

 @li_RoomConfigurationXid int, 

 @li_NoOfNights  int,

 @li_Sequence  int,

 @li_OldSHCDataDtlXid int,

 @li_BaseCurrencyXid int,

 @li_SHCDataDtlXid int,

 @li_SortHCDataDtlsXid int,

 @li_CurrencyXid  int,

 @li_QuickBedHotelRoomTypeXid int,

 @li_OldChargeTypeXid int,

 @li_HolidayContractXid int,

 @li_OldRConfigDtlsXid int,

 @li_HCSupplementXid int,

 @li_SupplementXid int,

 @li_OriginalChargeTypeXid int,

 @li_OldRoomTypeXid  int,

 @li_OldRoomConfigurationXid int,

 @li_OldSequence  int,

 @li_HolidayDiscountXid int,

 @lv_ValidOn  char(7),

 @lc_BaseContractLevel char(3),

 @lc_MinimumStayApplyOn  char(1),

 @lc_AvailabilityStatus char(1),

 @lc_InsertYN  char(1),

 @lc_ClosePaxConfigTag  char(1),

 @lc_ClosePaxRoomTypeTag char(1),

 @lc_ClosePaxRootTag  char(1),

 @lc_PayableBy  char(1),

 @lc_Mandatory   char(1),

 @lc_PerWhat  char(2),

 @lc_PercOrAmt  char(1),

 @lv_BaseContractType varchar(25),

 @lv_SellRateString varchar(3000),

 @lv_XMLString  varchar(8000),

 @lv_TempString  varchar(8000),

 @lv_RoomTypeXid  varchar(1000),

 @lv_RatesFor  varchar(25),

 @lv_SubString  varchar(20),

 @ld_BaseDate  datetime,

 @ld_StartDate  datetime,

 @lm_Value  money,

 @lm_DateRate  money,

 @lm_ExtraNightRate money,

 @lm_RoomRate  money,

 @lm_Discount  money,

 @lm_RateDifference money,

 @lm_SupplementRate money,

 @BookingAcross  int,

 @li_ToQty  int,

 @lc_TypeOFQty  char(1),

 @lv_ContractType varchar(10),

 @lv_LastString  varchar(8000),

 @li_MaxRoomDetailsPid int, 

 @li_LastHotelXid int,

 @ld_SuppToDate  datetime

DECLARE @HotelFacilities TABLE

(

FacilitiesXid int

)

DECLARE @RoomFacilities TABLE

(

FacilitiesXid int

)

DECLARE @Hotels TABLE

(

HotelXid int

)

DECLARE @RoomConfiguratrion...

Hi, Run generate script option by right clicking on database option in SQl Server Enterprise Manager, go to Option tab in screen and click the Index check box