> >>Sorry if this is a regular question but can somebody tell me how to
> >>spool query results to a text file rather than to the screen in ISQL.
> >>Ive seen it done in Oracle but for the life in me I can't find any
> >>mention of how to do this in SQL-Server except for creating some sort
> >>of mail client. I would of thought this would be a standard
> Im sorry I didn't make myself clear in the original question. The
> server is kept at a different site so I really need to do this in ISQLW
> unless someone can tell me how to get ISQL onto my client
> Am I being thick or have I just not been looking in the right places.
> Michael McSkeane
You should be able to use a UNC filename for the output from either ISQL
isql /U xx /P xx /S xx <scriptfile.sql >\\wkstation\share\dirpath\file
bcp db.owner.table out \\wkstn\share\dirpath\file /f fmtfile
or map the share to a drive letter.
You'll need pernmission to access the share (create one or use the
default c$ share) on the target PC.
Alternatively, you may install the SQL utilities (use the SQL Server
CD-ROM setup and pick "utilities only" option) and have the client PC do
a "pull" with bcp or ISQL when it's ready. NT workstations can run the
scheduler service and schedule the job via the "at" command or W95
workstations can run a job via System Agent (from the W95 Plus disk, I
think) other scheduler utilities.
Opinions expressed herein are my own and may not represent those of my employer.