Hi all,

Thanks a lot for the info, advice and kind assistace given to me so far.

Really appreacite it, thanks again.

Hi all,

Thanks for all the replies,

I am not expecting any tuning on the script..

Just would like to get more info on the sql db engine which has all default setting...

The column data type is varchar(15).

In fact, I have the index rebuild and statistics update just after the restoration from the backup.

FYI, after i change the cost of threshold of...

hi,

how can we determine the cost is 3?

Since the cost is 3, it is under the default value of 5, means the SQL Server should choose to execute the query...

Hi,

Please kindly see the execution plan from the attachment.

Thanks for the advice again.

SQL 2000 (execution timing 1 sec)

SQL 2005 (execution timing 2min 34 seconds)

Hi,

Jst a question,

when i rewrite the query as below...

the query seemed to return very fast result..

can anyone explain why like this?

declare

@productcode varchar(10)

set @productcode = '18346500'

select top 1 productcode,...

means below approach is safe to go?

1) execute sp_delete_maintenance_plan 'xxxxx'

2) delete from msdb.dbo.sysdbmaintplan_history where plan_id='xxxxx'

hi all,

thanks for the time and effort help given..

just would like to know whether i can delete the MP using below stored procedure?

sp_add_maintenance_plan ?

however, the stored procedure is just deleting...

no blocking as well...

there should not be a blocking happen as i should be notified through my blocking alert notification..

my concern is...

will this MP affect any of my current DB engine operation?

if it...

no..

there is no open transaction..

yes, i have deleted the job..

after that i did create new maintenance plan for DB full backup and log backup,the two new jobs (generated from MP) are working fine without...

Thanks for the help.

FYI, i m using SQL Server 2000 instead..

the manual delete query stated above is referring to SQL Server 2005 ?

there is no change on the hostname as...

hi,

does it mean that if i rewrite the query as below,the log file will be reused?

BEGIN TRANSACTION

update a...

GO

update b...

Go

COMMIT TRANSACTION

BEGIN TRANSACTION

update c...

GO

update d...

Go

COMMIT TRANSACTION

BEGIN TRANSACTION

update e...

GO

update f...

Go

COMMIT TRANSACTION

My log file...

Isn't auto commit is a nature of sql server? (correct me if i am wrong)

in my case, my script look like below:

update.....

update....

update....

...

..

...

After the first statement update completed,it is not considered...