This is a long shot, but is it possible your user has a File DSN set up with the same name as the System DSN on other machines?

SQL Prompt.

Doesn't TOP need an ORDER BY clause?  (Otherwise, how does the server know the meaning of TOP?) Try adding one to your subquery.

I am unable to use Profiler on my database. When I try to, it tells me I need ALTER TRACE permissions.

BOL doesn't spell it out, but it implies that you...

I have a friend who worked for a Microsoft support team back in the '90s. One day a customer called up, complaining that Windows wasn't starting. "Ma'am, did you delete...

Try exporting your table to Excel.  It has some nice functions that allow splitting out data.

Example:  Cell A1 has "Seattle, WA 98155"

To get city:  =LEFT(A1,SEARCH(",",A1)-1)

2-letter State:  =MID(A1,SEARCH(",",A1)+2,2)

5-digit zip code:  =RIGHT(A1,5)

You may need...