I am running SQL 2005, so do i need to install nay add-on patches to my sql server?

What is SSIS?

thanks solved.

Just simple registration wizard.

Sorry for the delayed reply, my main concern is not to interrupt any database or its related services.

as this is my production server. So the command you have mentioned will...

I havent tried to register the sql server in this user profile's Enterprise Manager.

How can i check if this user have administraive right to sql server, I have added the...

Thanks,

Its working,

But the last select is not updaing the tim col.

I can make it work till the x column.

it seems 24hrs format, but we need in the 12 hrs format to show AM/PM.

A friend have given me access code that seems working with him

Format(Asc(Right([PrevDate], 3)) - 48 &...

+------------------+---------+

| TimCol | Col2 |

+------------------+---------+

| 09:03:24 AM | test1 |

| 10:15:35 AM | test2 |

| 12:10:02 PM...

I have resolve it in my way, i don't know if its correct or wrong to to long process etc.

but the output is satisfactory. I have First created view...