Re: xp_cmdshell not creating txt file
From: D (D_at_discussions.microsoft.com)
Date: 07/19/04
- Next message: Simon: "Re: Database access"
- Previous message: Kalen Delaney: "Re: Database access"
- In reply to: Aaron [SQL Server MVP]: "Re: xp_cmdshell not creating txt file"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 13:02:01 -0700
Thank you so much that worked for me.
"Aaron [SQL Server MVP]" wrote:
> You're going to have to create a share on the SQL Server so that it can push
> the file to, e.g., X:\ (SQL Server will never see YOUR C:\ as C:\).
>
> Or, have the code run from your machine and pull the data from the remote
> SQL Server. Then you'll have to worry less about permissions from the SQL
> Server side to your desktop.
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "D" <D@discussions.microsoft.com> wrote in message
> news:F24CBEF1-952A-4A35-8112-BFE9FBF23F72@microsoft.com...
> > They're different drives. The code works if I put it on the server now
> because I got permission to put it there but I want it on my hard drive.
> >
> > "Aaron [SQL Server MVP]" wrote:
> >
> > > > I need a txt file to be created on my hard drive.
> > >
> > > Are your hard drive and SQL Server's hard drive the same drive, or are
> they
> > > different drives?
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> > >
>
>
>
- Next message: Simon: "Re: Database access"
- Previous message: Kalen Delaney: "Re: Database access"
- In reply to: Aaron [SQL Server MVP]: "Re: xp_cmdshell not creating txt file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
