Thanks Phill, I havn't tracked down the corect file in that directory yet and I'm still trying to sort out what information each file holds.

I amhoping that the answer is...

Great! Hmm i guess it doesn't match the nulls cause its not "IS NULL"

Im not saying that this is the best solution but just for the fun of it I think it should work.

in code assuming an array of values for your IN...

I was just browsing another post where a guy/gal was having troubles passing a param to a job. Someone suggested having the code write the param to atable, then having...

Ya well I did something like that. I created a table with 5 years worth of dates times rounded to the hour as datetime fields.

Then I wrote a UDF that take...

UDF's to ther rescue! I'll answer my last question myself. using the sample UDf in C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Misc. as a base I'll modify it to take a datepart type...

I have a related question:

there are many times when I want to group by individual days in a datetime field.  I always finding myself thinking there has to be a...

yes I'm writting a job to keep this lookup table up to date to avoid any y2k situations in the app

Thank you that looks like a fine solution I just have to weave it in:

CREATE TABLE TTT (dte datetime, val int)

GO

INSERT INTO TTT (my select statement)

--hmmm then the date range...

OK this has resulting in another question.  I successfully backed up my transaction log but the file size still shows as 350mb.  Space used is only 20mb.

I went into the...

Well I answered the question myself, NO I can't just delete the transaction log.  Fortunetly for me a complete chkdisk managed to correct the issue, I only had to wait...

I use Dev Wizard http://www.q-d.com/dw.htm. Design your tables and it'll write your procs, vb com props and methods and even the asp forms.

Yes thank you I did go check the logs now. The error is in accessing the directory I specified.  At first I thought it might be a permission problem but then...

As usual an idea hit me just as I posted. I ran the step from QA and i get this error:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 75BB91A2-3F0A-42BB-B22E-33ECDAEAB88E -Rpt "E:\_sqlData\MSSQL\LOG\Full maintanence plan6.txt" -DelTxtRpt 4WEEKS...

single line appears to only happen when following link from notification email