Thanks Paul

Raghu

I tried that and it works...even though it is somewhat ugly ! Also, I ignored Elapsetime field altogether and did a datediff on starttime and endtime (both datetime fields) and...

it is in hh:mm:ss format but the field carrying the data has varchar(20) datatype

Raghu

Sample data for elapsetime is as :

80:3:57

80:3:54

33:20:49

58:8:20

14:1:59

7:22:17

0:13:37

5:6:0

1:3:47

0:22:57

8:22:37

4:4:44

7:22:23

27:18:12

7:7:14

3:0:20

26:18:47

0:2:9

0:3:23

1:14:54

0:5:38

0:5:29

0:2:59

0:5:36

0:3:31

1:1:38

30:3:52

25:17:59

5:20:42

4:1:23

10:3:31

1:22:47

1:1:12

5:20:18

3:21:51

3:17:56

0:5:24

17:23:28

4:4:02

3:17:52

4:4:00

3:2:07

3:22:16

3:22:16

15:2:36

1:5:08

1:4:31

5:20:34

5:21:38

5:21:30

11:1:4

7:7:31

1:17:26

1:1:42

0:23:27

0:2:0

0:1:15

0:1:53

1:1:52

0:20:41

Thanks a lot

Raghu

I tried that...I get this errror

Server: Msg 409, Level 16, State 2, Line 1

The average aggregate operation cannot take a datetime data type as an argument.

Raghu

Thanks for the web link

But We have NDS From Novell as our Domain controller not Active Directory. I am lost as I cannot do my work-around like it was suggested...

Thanks a lot everyone...this is really helpful

Raghu

Thanks Kay_dba this helps...

where do I get this information from?

I looked in microsoft web site but I could not find the relevant numbers for service packs.

I will keep looking but...

Thanks for the replies...can I do something about it like compress the file (within Enterprise Mgr) also I am backing up my transaction logs every hour...

I cannot backup during working...

Thanks I will try that, one more question...recovery is cumulative is'nt it.

I can go to Sunday's full back up file recover it with norecovery option then jump to Friday's differential...

It is set to 0 (unlimited)

Raghu

Thanks for all your suggestions, I can start thinking on each one of them and try it out...I will let you guys know how I made out.

Thanks again

Raghu

I found the problem, even though I was on the network my machine was not registered to the Domain. That fixed it!

Raghu

Thanks Andy I will take the replication route and see where it takes.

Thanks again

Raghu

Thanks I do see the following message

Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50

Copyright (c) 1988-2000 Microsoft Corporation

Developer Edition on Windows NT 5.0 (Build...