Is patients the name of a database? If so, USE patients.

Otherwise, in SQL server you do not just SELECT a workarea. You can Select * from Patients.

>This is the last line of my script:
>
>

>Select Patients
>

>
>I get this error:
>
>

>Msg 102, Level 15, State 1, Line 258
>Incorrect syntax near 'Patients'.
>

>
>If I put something else at the end of the script, like this:
>
>

>Set NOCOUNT OFF
>

>
>Then the error is:
>
>

>Msg 102, Level 15, State 1, Line 258
>Incorrect syntax near 'OFF'.
>

>
>What's going on?