Wat exectly you want ..please clarigy ur requirement ???

Actually creating/droping is for spped up the insertion

and NOLOCK is just to avoid locking becuase i m sure i wont get dirty reads

Well Gila...is there any...

hi

i understand your points......well now i m attaching whole script which is need to be tuned so please have a look and give ur suggestionn

yes u are right

this is the IO results

--------------------------------------------------------------

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 7 ms.

--------------------------------------------------------------

View Defnition :

CREATE VIEW...

CREATE TABLE [dbo].[DMP_EVENT_EVENT](

[event_id] [int] IDENTITY(1,1) NOT NULL,

[event_code] [dbo].[ut_friendly_code] NULL,

[event_status] [dbo].[ut_short_description] NULL,

[start_date] [datetime] NULL,

[end_date] [datetime] NULL,

[rsvp_by_date] [datetime] NULL,

[activate_date] [datetime] NULL,

[approval_date] [datetime] NULL,

[event_category] [dbo].[ut_medium_description] NULL,

[capacity] [int] NULL,

[currency] [dbo].[ut_short_description] NULL,

[event_title] [dbo].[ut_long_description] NULL,

[description] [ntext]...

hi please find execution plan ZIP

hi gila,

actually i dont know how to attach Zip and also how to save execcution plan file

how to set JOB ,to work it when system sits in IDLE state

hi

actually following are the steps i need to do.

1.On every alter or create Stored proc ,A DDL trigger gets fired

2.DDL trigger insert SP name into SYNC_OBJECT_SEND_IN

3.JOB continuosly...

can anybody help me ??

i got stuck BADLY 🙁

can anybody help me ??

yeah i am sure.when i am ryt click the maint.plan to create new plan, then it's giving this error. without resolving this error how can i start main.plan. manually.basically...

thanks for reply but

its giving same error with below script

------------------------------------------------------

SET ANSI_NULLS on

GO

SET QUOTED_IDENTIFIER on

GO

create proc sp_test1

as

select getdate()

before which create statement i need to do it ??

now i m getting this error

[GROUP_ITEM_DETAIL [962]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009. There...