I am probably wrong, but I believe these queries will have to be run in SSMS. Not sure if the OP will know how to download and install that although it is fairly straightforward. You also need the right version for the current SQL version. If you install SQL yourself, then there is a setting where you can choose to log into SQL using Windows Authetnication. However, if AC does it, you will need the sa username and password. This won't be a problem for James, but it will be a showstopper for the OP. ANd, the queries, while written out step by step can be screwed up.

It would just be simper if James remoted in, installed SSMS and ran the query. Just my guess.


Bert
Pediatrics
Brewer, Maine