Viewing 15 posts - 6,811 through 6,825 (of 7,429 total)
Yeah I have seen thst too, seems to a be a toolbar refresh problem. If you double click the time and open the diaglog it shows the right time and...
March 17, 2002 at 12:14 pm
Also there were revisions made in MDAC 2.6 for 2000, which it was the version shipped with 2000.
"Don't roll your eyes at me. I will tape them in place." (Teacher...
March 16, 2002 at 1:43 pm
But that still doesn't correct tha fact that SQL is 40+ seconds to sync with the OS, NTP only affects the time in the OS until SQL syncs. The problem...
March 16, 2002 at 1:41 pm
From BOL
Error 823
Severity Level 24
Message Text
I/O error %ls detected during %S_MSG at offset %#016I64x in file '%ls'.
Explanation
Microsoft® SQL Server™ encountered an I/O error on a read or...
March 16, 2002 at 6:36 am
That we know the question at this point is why SQL7 does not react the same as 2000 does?
"Don't roll your eyes at me. I will tape them in place."...
March 16, 2002 at 6:29 am
DATEDIFF ( datepart , startdate , enddate )
do
SUM(CASE WHEN DATEDIFF (d, datalc, getdate()) < 30 THEN deb ELSE 0 END) AS 30Days,
SUM (CASE WHEN DATEDIFF (d, datalc, getdate()) >...
March 16, 2002 at 6:26 am
How are you currently outputting?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 15, 2002 at 3:03 pm
See duplicate thread.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 15, 2002 at 2:39 pm
Not directly, however if you are using SQL 2000 you could build a function to check unique with exceptions.
"Don't roll your eyes at me. I will tape them in place."...
March 15, 2002 at 2:38 pm
Check out http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acmthactSendObject.asp
But basically
DoCmd.SendObject acReport, stDocName, acFormatRTF
should so the job.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 15, 2002 at 2:36 pm
That's cool, there is just so much to know it will always seem like the first time some days.
"Don't roll your eyes at me. I will tape them in place."...
March 15, 2002 at 2:10 pm
Sorry bout that, put in the wrong one.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 15, 2002 at 2:08 pm
This is because views remember the ordinal positions in a table, the same is true for stored procedures. To make sure they become aware of the updates run
sp_recompile 'objectname'
against the...
March 15, 2002 at 1:03 pm
GO to looking and noticed you used
quote:
on error resume next
Take it out and...
March 15, 2002 at 12:58 pm
If Left(DTSSource(SourceCol),1) = "1" then
DestValue = mid(DTSSource(SourceCol),4,2) + "/" + mid(DTSSource(SourceCol),6,2) + "/20" + mid(DTSSource(SourceCol),2,2)
Elseif Left(DTSSource(SourceCol),1) = "0" then
DestValue = mid(DTSSource(SourceCol),4,2) + "/" + mid(DTSSource(SourceCol),6,2) + "/19" + mid(DTSSource(SourceCol),2,2)
Else
DestValue =...
March 15, 2002 at 12:53 pm
Viewing 15 posts - 6,811 through 6,825 (of 7,429 total)