HI,

your code will not change the value of @id when the saNumber changes.

all records having '101' should have one unique identifier number

all records having '102' should have one unique...

Hi arun,

thanks for ur reply.

but 'id' column data type is unique identifier( i can't change the data type).

so i want to generate one unique identifier and apply it to all...

Hi,

Thanks for your inputs.

but i don't need ranks on those columns.

i want to update a field with newly generated unique identifier in all the saNumber which are same.

for example,

all the...

Thanks Dave,

is there a way to update a field with a newly generated unique id of all records having the same saNumber?

for ex. all '101' should have the same...

the back up and restore from one network to another worked properly.

thanks ALZDBA

regards

anamika

thanks,

i started trying bakup. let it get complete .i'll restore and ping you back.

( while taking the maf & ldf, i've dettached the database)

thanks,

regards,

anamika

thanks,

but to take a back up i don't have space in the server. it'z a 200gb database.

regards,

anamika

thanks

i'll look into Bi documentor also..

--viji

thanks for the quick reply.

i find some tools to do this and get the same into html format.

right now i'm trying the same

thanks,

regards

viji

Even i've tried with

SELECT CONVERT(VARCHAR ,createddate , 111) DATE , CASE WHEN COUNT (*) IS NULL THEN 0 ELSE COUNT(*) END COUNT

FROM tro WHERE CONVERT(VARCHAR ,createddate...

Hi Bob Hovious,

thanks for ur reply.

but it ddn't work 🙁

SELECT CONVERT(VARCHAR ,createddate , 111) DATE ,COUNT (*) COUNT

FROM tro WHERE (CONVERT(VARCHAR ,createddate ,111)

BETWEEN '2009/02/01' AND '2009/03/31'...

Hi,

i found the solution

declare @SPName Varchar(255)

DECLARE CsrProcName CURSOR FOR

SELECT NAME

FROM sys.objects

WHERE type IN ('FN', 'IF', 'TF','P')

OPEN CsrProcName

FETCH NEXT FROM CsrProcName INTO @SPName

PRINT @SPName

WHILE @@FETCH_STATUS =0

BEGIN

insert #tmp

exec sp_depends...

Thanks,

the suggestions helped me a lot.

regards

viji

sorry,

let me be more clear

i want to close all the connections but not to take the db offline.

is there a command to do all this by one shot becoz KILL...

thanks,

is there any other command just to close all the connections??

regards

viji