Exec SP with @Param in external file

Hi I have googled but could not find the answer how can I do the
following.
exec my_sp < foo.csv
I.e feed my_sp with the contents of a external file?
my_sp expects one parameter @.param1
the csv file or tsv or whatever looks like this:
1
2
3
4
5
6
7
8
9
10
.....
is this poss?
thanksYou could easily use VB or VBScript to open the file using
Scripting.FileSystemObject, read through line by line, and EXEC the SP using
the value found on each line.
This will be much more difficult (though not impossible) to construct in
T-SQL, and I recommend you do this kind of processing outside of the
database and use T-SQL as a last resort.
"red" <cap_sch@.yahoo.co.uk> wrote in message
news:1124113881.153729.316840@.g14g2000cwa.googlegroups.com...
> Hi I have googled but could not find the answer how can I do the
> following.
> exec my_sp < foo.csv
> I.e feed my_sp with the contents of a external file?
> my_sp expects one parameter @.param1
> the csv file or tsv or whatever looks like this:
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
> .....
> is this poss?
>
> thanks
>|||sp must first establist an openrowset, openquery
or a linkedserver to the csv parameter
sp must then throw the query
to the establish connection
"red" wrote:

> Hi I have googled but could not find the answer how can I do the
> following.
> exec my_sp < foo.csv
> I.e feed my_sp with the contents of a external file?
> my_sp expects one parameter @.param1
> the csv file or tsv or whatever looks like this:
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
> ......
> is this poss?
>
> thanks
>|||If we can have a look at your procedure, maybe we can suggest a set-based
solution. After all - T-SQL is set-oriented.
ML

Exception Access Violation

We are running SQL Server 2000, SP 3, and today have begun receiving the
following error: "Process 88 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
The error is occurring about every hour and appears to occur when an hourly
job is run to backup the transaction log for a db. The transaction log is
backed up and then the error appears to occur when SQL Server tries to write
a text report following the transaction log backup, the steps are part of a
database maintenance plan. This is the first time we've ever had a problem
with these jobs and they've been running for about 4 years now and no changes
have been made to the jobs.
Any help is appreciated. Thanks
In this case, you may have to call SQL Server support. SQL Server
has choked on something.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
write
> a text report following the transaction log backup, the steps are part of
a
> database maintenance plan. This is the first time we've ever had a
problem
> with these jobs and they've been running for about 4 years now and no
changes
> have been made to the jobs.
> Any help is appreciated. Thanks
|||While you should probably call PSS, the first thing they will ask is if you
are up to date on SPs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
> hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
> write
> a text report following the transaction log backup, the steps are part of
> a
> database maintenance plan. This is the first time we've ever had a
> problem
> with these jobs and they've been running for about 4 years now and no
> changes
> have been made to the jobs.
> Any help is appreciated. Thanks

Exception Access Violation

We are running SQL Server 2000, SP 3, and today have begun receiving the
following error: "Process 88 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
The error is occurring about every hour and appears to occur when an hourly
job is run to backup the transaction log for a db. The transaction log is
backed up and then the error appears to occur when SQL Server tries to write
a text report following the transaction log backup, the steps are part of a
database maintenance plan. This is the first time we've ever had a problem
with these jobs and they've been running for about 4 years now and no change
s
have been made to the jobs.
Any help is appreciated. ThanksIn this case, you may have to call SQL Server support. SQL Server
has choked on something.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
write
> a text report following the transaction log backup, the steps are part of
a
> database maintenance plan. This is the first time we've ever had a
problem
> with these jobs and they've been running for about 4 years now and no
changes
> have been made to the jobs.
> Any help is appreciated. Thanks|||While you should probably call PSS, the first thing they will ask is if you
are up to date on SPs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
> hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
> write
> a text report following the transaction log backup, the steps are part of
> a
> database maintenance plan. This is the first time we've ever had a
> problem
> with these jobs and they've been running for about 4 years now and no
> changes
> have been made to the jobs.
> Any help is appreciated. Thanks