Viewing 15 posts - 1 through 15 (of 15 total)
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...
October 14, 2003 at 11:19 am
it is in hh:mm:ss format but the field carrying the data has varchar(20) datatype
Raghu
October 14, 2003 at 10:03 am
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
October 14, 2003 at 9:45 am
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
October 14, 2003 at 8:59 am
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...
August 21, 2003 at 11:15 am
Thanks a lot everyone...this is really helpful
Raghu
July 15, 2003 at 7:19 am
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...
July 15, 2003 at 6:39 am
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...
March 20, 2003 at 10:37 am
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...
February 4, 2003 at 9:40 am
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
June 17, 2002 at 3:26 pm
I found the problem, even though I was on the network my machine was not registered to the Domain. That fixed it!
Raghu
May 7, 2002 at 9:11 am
Thanks Andy I will take the replication route and see where it takes.
Thanks again
Raghu
May 6, 2002 at 7:55 am
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...
May 1, 2002 at 6:33 am
Viewing 15 posts - 1 through 15 (of 15 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy