Sorry i mean date and time it Ran?

How can i pull the time it Ran?

Thanks for the comments

do you mean to use this way

Select (UALog.*)

or

Select * (UALog)

Its not showing any delay in trace

Here is the Execution Plan

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.0.4000.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

<BatchSequence>

<Batch>

<Statements>

...

Thank you SIr

No no as you mentioned about un necessary repetative part of SP, thats what i meant

can you please post the changes you like to make then i will test it?

Regards

This SP is running ON

Microsoft SQL Enterprise Manager

Microsoft Corporation

Version: 8.0

Thanks its resolved

Means i will have to first restore full database backup,

and then all the transactional log backups since the last full backup with no recovery?

and last transactional log backup with recovery????

The table where i need to add a column that is already replicated.

Its Resolved,

THanks for the participation

Msg 207, Level 16, State 1, Line 13

Invalid column name 'NumberRows'.

Msg 207, Level 16, State 1, Line 13

Invalid column name 'Time_stamp'.

Thanks