The is a log but only if you have it turned on in DTS Package proerties. If not then you won't have one for anything prior to changing that.

So SQL 7 with Maintenance Plans. Do you have the "Repair Minor Problems" option set? If so remove it as that has been a major buggy piece and could be...

Nah, Andy's not attentive he is just trying to catch me.

First is there an INDEX on Expired or Last_visit and...

There are several ways to accomplish however most require you have a single field you can use to order the data. And to get proper results it should be a...

INSERT db1.objectowner.tblname (collist)

SELECT relativecollist FROM db2.objectowner.othertblname

If you follow that format and get an error then we need to know the error to help further.

The N'string values' unicode designator means interpret the data in the string as a unicode value with explicily do the whole CAST('A' as NCHAR(1))or other type of data type conversion....

Usefull but does come at a price on Network and Hardware resources so be carefull there. Also, their licensing is explicit about setting up for one server (which you must...

Can you explain in more detail your code. Are we talking SQL variable or ASP variable and how many items. An example would help.

They are called CASE statements. See SQL BOL for more information.

Did you have any text fields in the tables. I believe Andy is right but am curious about the later as text does not compress if there is free space...

Try instead

AVG(CAST(TS.TestScore AS Decimal(4,2))) AS Average_Score

When the average is done it keeps the datatype the same as those pushed into it. Thus a smallint remains a smallint. But if you...

What are the conditions then if you have to wipe the computer one this?

If they are no longer selling you the software for use on yuor machine and reuse if...

See if this article applies.

quote:

---

http://support.microsoft.com/default.aspx?scid=KB;en-us;q246181

---