Unable to execute DTS jobs migrated to Version 2005...Arg!!!!!!  The learning curve for SSIS is VERY steep...I have to re-write every DTS package in 2005 before I can migrate

What problems...

Try this. It's not tested, but should work. It depends on the dummy course been the only one that all students take.

SELECT

*

There's nothing else? Foreign key? Flag anywhere?

It's doable, but it's not going to be a nice query. Let me see what I can come up with....

Remove the distinct from the in. x in (1,2,2,2,2,5) and x in (1,2,5) are equivalent.

Make sure you have an index on SKey and FTSKey.

Also, try the query as a left...

What distinguishes a dummy course from a real one?

I can give you a query that will find students with a single course, but if they have multiple, there will have...

I read about this on a blog some months back. Can't remember which one. I'm pretty sure it was one of the SQL dev teams.

SQL Server 2005 is under no...

There's no need to create a DTS package just to run a stored proc. A SQL Agent5 job is more than sufficient.

No need to add additional complexity.

What's your question?

Image stores binary data, not text. For storing large amounts of text data use the text or ntext data types.

select suser_sname()

This is assuming they're using windows authentication to connect to the server. If thery're using sql authent, then there's no way I know of to find the windows login.

Don't know about the first or last. The error says there's a syntax error near '-', but there are no dashes in what you've posted.

There's also a syntax error in...

No, I meant a real table. Depending whether you need the variables global across all connections or global across all queries on a single connection you could have aa spid...

A variables table?

The security around the metadata has been changed from 2000 to 2005. Only if a user has some right to an object can they see it in the system views.

Back the database up and restore it to a 2005 server. The db will be converted during the restore. Update all the statistics afterwards, if you can.

You should check afterwards...