I like identities, especially for something like this. A multi-page form, where you'll like to store the data after each page in case the session breaks and they need to...

CDATE isn't a valid T-SQL function, it's ASP.

How is the ASP syntax structured?

Usually you'd do something like

strCMD = "SELECT dbo_CallLog.CallID AS Ticket, dbo_CallLog.Category, dbo_CallLog.CallDesc, dbo_Asgnmnt.Notes, " + CDate((dbo_Asgnmnt!DTLastMod/60/60/24)+25569)+

" AS...

I agree with Gail. Truncating the log isn't something you want to regularly do. It's kind of an emergency feature, not something you want to use regularly.

Are you converting different numbers like this?

1,2,3,4

Those are characters if you delimit them. SQL doesn't recognize arrays or delimited strings as a set of numbers. It's a character string.

Or just leave the log size larger. It's obviously needed for the operation and a larger log doesn't affect the way your system runs (other than needing disk space).

I'm not...

I thought it was an interesting story about how easy it is to overlook something. It's good to be reminded regularly that indexes matter and that new features, like CTEs,...

We are a heavy user of the forum software. Perhaps the largest, and I'm not sure how many people have the 500 post issue.

Adding threads to the briefcase is something...

Interesting idea. I'll pass along to the forum vendor. Changes like that we try to get them to incorporate.

SQL 2000 is a great, stable platform and it's served me well in many situations. I've had all kinds of businesses run well on it, including this one. We upgraded...

Glad to hear you're OK, GRant, that's a scary story. I always worry when I'm working with power tools.

I try not to step in and let things run on their...

I think the certifications can enhance your experience, but if you get them without experience, then you are proving you can study and test, but not necessarily do anything.

In other...

The Microsoft courses are all taught from a standard curriculum, so the instructor doesn't really matter.

If you're looking to pass the tests, the MS courses are standard. If you want...

Maybe you could target meeting some SLAs, perhaps responding to all requests within xx days or answering all emails within a day or something that shows you are working well...

The script above should help, but why would that date impact whether or not something was being decommissioned? I'd think it was being used or not.

Be aware that you might have issues with this if the server is at 100% CPU. You might want to set something up with a monitoring solution on the Windows...