data type is real

I gave my expected result above.

I have a column which has week number like 1 to 52 but i want to update them with prefix year like 2009.1,2009.2......2009.52

this is not working it is just adding to the existing number say if i have 1 the result is 2010 adding 1 to 2009.

Expected result :

1 = 2009.1

2 =...

I feel that the issues caused after installing cumulative updates is that dll files failed to re-register and so we run into problems.

Assuming this i would like to register...

OK here is the soluciton for my recent problem which allowed me to connect to SSI services.

I have to register the dll file as below

regsvr32.exe "\90\DTS\Binn\MsDtsSrvrUtil.dll

But my problem with packages...

Update on this problem;

I can not even connect to Integration services on this servers, i get the error that says

TITLE: Connect to Server

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

Cannot connect to OBBEAVER.

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

ADDITIONAL INFORMATION:

Failed to retrieve...

I am having the same issue after installing this update on SQL 2005 SP3(GDR 4053) .

is there any fix ?

When i click on remove from Add/Remove Programms i get this which scares me to go ahead as that may uninstall my sql server

T

he following products can be uninstalled by...

How do i rollback just the hotfix which i recently installed without effecting sql server installations or any sql server datbases on that box.

any suggestions to fix this ?

Nope, we never change pswd for service accounts which run sql server.

Bru

that is not the original date it gets updated when i restore or move it from another server.

I dont think the date is correct, i get 2005-10-14 01:36:06.690

for all the dataabses in my server. even for the database which i created yesterday.

I dont see any difference, how can i get this in a single list, may be inserting in a temp table ?

Is this date original creation date, does it change...

is there a way i can get dbname,size and original creation date of all databases in the server ?