Running BCP from a webserver

I am executing BCP within a web application. SQL Server
client is not installed on the web server there although
we have copied the BCP.exe and BCP.RLL, an error message
displays saying it is missing the Resource Library. What
are my options to get this work?
Robert Complusman (anonymous@.discussions.microsoft.com) writes:
> I am executing BCP within a web application. SQL Server
> client is not installed on the web server there although
> we have copied the BCP.exe and BCP.RLL, an error message
> displays saying it is missing the Resource Library. What
> are my options to get this work?
The simplest would be to run the SQL Server install on the web server,
and install "Tools and utilities only". Now, whether this is
compliant with your license, I don't know.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
|||Hi
Maybe you would be better using Bulk Insert?
You may also want to consider using a DTS job to get (FTP) the file and put
it onto a different server, then process it.
John
"Robert Complusman" <anonymous@.discussions.microsoft.com> wrote in message
news:1974701c44cc6$df510140$a001280a@.phx.gbl...
> I am executing BCP within a web application. SQL Server
> client is not installed on the web server there although
> we have copied the BCP.exe and BCP.RLL, an error message
> displays saying it is missing the Resource Library. What
> are my options to get this work?
sql

running an exe file SQL server agent

Hi ,
I have an exe program that i do not want to be part of
the services however , i do want it to auto-start when the
server is rebooted.
it is possble to configure it as part of SQL server
Agent job ?
thks & rdgs
maxzism,
Whilst it is possible, it may not necessarily be desirable. What exactly
are you trying to do? Using the Startup folder in windows, or using the
'at' command, or some other software may be a better option.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
maxzsim wrote:
> Hi ,
>
> I have an exe program that i do not want to be part of
> the services however , i do want it to auto-start when the
> server is rebooted.
> it is possble to configure it as part of SQL server
> Agent job ?
>
> thks & rdgs

running an exe file SQL server agent

Hi ,
I have an exe program that i do not want to be part of
the services however , i do want it to auto-start when the
server is rebooted.
it is possble to configure it as part of SQL server
Agent job ?
thks & rdgsmaxzism,
Whilst it is possible, it may not necessarily be desirable. What exactly
are you trying to do? Using the Startup folder in windows, or using the
'at' command, or some other software may be a better option.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
maxzsim wrote:
> Hi ,
>
> I have an exe program that i do not want to be part of
> the services however , i do want it to auto-start when the
> server is rebooted.
> it is possble to configure it as part of SQL server
> Agent job ?
>
> thks & rdgs

running an exe file SQL server agent

Hi ,
I have an exe program that i do not want to be part of
the services however , i do want it to auto-start when the
server is rebooted.
it is possble to configure it as part of SQL server
Agent job ?
thks & rdgsYes,
Look up the xp_cmdshell command, and the SQL Agent 'Start
up Automatically when SQL Agent Starts' in schedule.
Peter
>--Original Message--
>Hi ,
>
> I have an exe program that i do not want to be part of
>the services however , i do want it to auto-start when
the
>server is rebooted.
> it is possble to configure it as part of SQL server
>Agent job ?
>
>thks & rdgs
>.
>|||maxzism,
Whilst it is possible, it may not necessarily be desirable. What exactly
are you trying to do? Using the Startup folder in windows, or using the
'at' command, or some other software may be a better option.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
maxzsim wrote:
> Hi ,
>
> I have an exe program that i do not want to be part of
> the services however , i do want it to auto-start when the
> server is rebooted.
> it is possble to configure it as part of SQL server
> Agent job ?
>
> thks & rdgs|||hi,
thks for ur info , i think it has solved my problem
rdgs
>--Original Message--
>Yes,
>Look up the xp_cmdshell command, and the SQL Agent 'Start
>up Automatically when SQL Agent Starts' in schedule.
>Peter
>>--Original Message--
>>Hi ,
>>
>> I have an exe program that i do not want to be part
of
>>the services however , i do want it to auto-start when
>the
>>server is rebooted.
>> it is possble to configure it as part of SQL server
>>Agent job ?
>>
>>thks & rdgs
>>.
>.
>

Running a vb.net exe from a dts

I'm trying to run a VB.NET exe from a dts.
This works when I run the DTS manually but just hangs when I schedule the DTS.
Has anyone seen this before ?Many times when you can run a DTS package manually, but not thru a scheduled job, it boills down to one of two things. Either you are running it from your machine instead of the server, or you have permissions that SQL Agent does not.

Physically logon to the SQL Server (not just open Enterprise Manager) and try to run your package ... if it fails, you were referencing files on your local box and not the server.

If it succeeds, then you need to look at the permissions of the service logon running SQL Agent verses your permissions.|||Thanks for the reply.
The DBA stated that the following error was found on the db server:

"Unable to Locate DLL - The Dynamic Link Library mscoree.dll could not be found in the specified path"

He is currently installing the .net framework on the sequel server.

Do you think this will do the job ?|||After installing the .net framework on the sequel server, I re run the dts and got the following message from the event viewer:

Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 0
Date: 22/05/2007
Time: 14:54:35
User: N/A
Computer: SQLXXXXX
Description:
The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: .NET Runtime version 1.1.4322.573- FraudDailyImport.exe - Common Language Runtime Debugging Services: Application has generated an exception that could not be handled.

Process id=0x1224 (4644), Thread id=0xe64 (3684).

Click OK to terminate the application.
Click CANCEL to debug the application..[/B]

Anybody got any ideas ?

Thanks in advance.sql

running a vb .net exe as a sql agent job

I'm primarily a vb .net developer, doubling (as many of us have to) as a sql
2000 dba.
I'm having difficulty running a vb.net exe as a sql agent job. I figured
out that sql 2000 can't really run a windows forms exe, as it thinks it
needs user interaction. However, since it can run an activex script, can it
also run a windows service produced in visual studio 2003?
Thanks for any help.
Bernie Yaeger
As I posted within .programming
I thought that windows service ran interactively (without the need to call
them via the command line)? It should be possible to run any exe that does
not have a gui and that does not require user interaction. There are
permissions issues that you will need to consider if you are not calling the
exe as dbo.
Keith
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:fETEc.60920$OT6.24612300@.news4.srv.hcvlny.cv. net...
> I'm primarily a vb .net developer, doubling (as many of us have to) as a
sql
> 2000 dba.
> I'm having difficulty running a vb.net exe as a sql agent job. I figured
> out that sql 2000 can't really run a windows forms exe, as it thinks it
> needs user interaction. However, since it can run an activex script, can
it
> also run a windows service produced in visual studio 2003?
> Thanks for any help.
> Bernie Yaeger
>
|||I'm curious, could you use xp_cmdshell and see if you could run it from
Query analyser, before you test it on sqlagent?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

running a vb .net exe as a sql agent job

I'm primarily a vb .net developer, doubling (as many of us have to) as a sql
2000 dba.
I'm having difficulty running a vb.net exe as a sql agent job. I figured
out that sql 2000 can't really run a windows forms exe, as it thinks it
needs user interaction. However, since it can run an activex script, can it
also run a windows service produced in visual studio 2003?
Thanks for any help.
Bernie YaegerAs I posted within .programming
I thought that windows service ran interactively (without the need to call
them via the command line)? It should be possible to run any exe that does
not have a gui and that does not require user interaction. There are
permissions issues that you will need to consider if you are not calling the
exe as dbo.
Keith
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:fETEc.60920$OT6.24612300@.news4.srv.hcvlny.cv.net...
> I'm primarily a vb .net developer, doubling (as many of us have to) as a
sql
> 2000 dba.
> I'm having difficulty running a vb.net exe as a sql agent job. I figured
> out that sql 2000 can't really run a windows forms exe, as it thinks it
> needs user interaction. However, since it can run an activex script, can
it
> also run a windows service produced in visual studio 2003?
> Thanks for any help.
> Bernie Yaeger
>|||I'm curious, could you use xp_cmdshell and see if you could run it from
Query analyser, before you test it on sqlagent?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

running a vb .net exe as a sql agent job

I'm primarily a vb .net developer, doubling (as many of us have to) as a sql
2000 dba.
I'm having difficulty running a vb.net exe as a sql agent job. I figured
out that sql 2000 can't really run a windows forms exe, as it thinks it
needs user interaction. However, since it can run an activex script, can it
also run a windows service produced in visual studio 2003?
Thanks for any help.
Bernie YaegerAs I posted within .programming
I thought that windows service ran interactively (without the need to call
them via the command line)? It should be possible to run any exe that does
not have a gui and that does not require user interaction. There are
permissions issues that you will need to consider if you are not calling the
exe as dbo.
Keith
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:fETEc.60920$OT6.24612300@.news4.srv.hcvlny.cv.net...
> I'm primarily a vb .net developer, doubling (as many of us have to) as a
sql
> 2000 dba.
> I'm having difficulty running a vb.net exe as a sql agent job. I figured
> out that sql 2000 can't really run a windows forms exe, as it thinks it
> needs user interaction. However, since it can run an activex script, can
it
> also run a windows service produced in visual studio 2003?
> Thanks for any help.
> Bernie Yaeger
>|||I'm curious, could you use xp_cmdshell and see if you could run it from
Query analyser, before you test it on sqlagent?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Runaway CPU

For some reason, for two days now, in the morning hours
the sqlservr.exe process is using an average of 94% of the
CPU on a very powerful server.
Can anyone tell me how to determine what the problem is,
without just rebooting the server?
Here are some Buffer Manager statistics in case it helps:
Buffer cache hit ratio 3044
Buffer cache hit ratio base 3048
Page lookups/sec 405446548
Free list stalls/sec 114
Free pages 291
Total pages 207872
Target pages 207872
Database pages 190592
Reserved pages 648
Stolen pages 16989
Lazy writes/sec 1722
Readahead pages/sec 477294
Procedure cache pages 14862
Page reads/sec 616224
Page writes/sec 658045
Checkpoint pages/sec 315881
Thanks.
Allen"Allen White" <awhite_nospam@.advanstar.com> wrote in message
news:21b501c4d885$f31e0f60$a501280a@.phx.gbl...
> For some reason, for two days now, in the morning hours
> the sqlservr.exe process is using an average of 94% of the
> CPU on a very powerful server.
> Can anyone tell me how to determine what the problem is,
> without just rebooting the server?
> Here are some Buffer Manager statistics in case it helps:
> Buffer cache hit ratio 3044
> Buffer cache hit ratio base 3048
> Page lookups/sec 405446548
> Free list stalls/sec 114
> Free pages 291
> Total pages 207872
> Target pages 207872
> Database pages 190592
> Reserved pages 648
> Stolen pages 16989
> Lazy writes/sec 1722
> Readahead pages/sec 477294
> Procedure cache pages 14862
> Page reads/sec 616224
> Page writes/sec 658045
> Checkpoint pages/sec 315881
> Thanks.
> Allen
>
Turn on Profiler..
What jobs (if any) are running? Do you have maintenance plans executing
that are rebuilding indexes?
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks, Rick. No maintenance plans are running. I keep a
trace running on all my production servers and have
reviewed the trace files and can see nothing that would
cause that kind of CPU activity. (The trace captures just
Batch Complete and RPC Complete activity.) I see lots and
lots of transactions, but nothing running for long periods
of time, nor anything that would be processor intensive.
Allen
>--Original Message--
>"Allen White" <awhite_nospam@.advanstar.com> wrote in
message
>news:21b501c4d885$f31e0f60$a501280a@.phx.gbl...
>> For some reason, for two days now, in the morning hours
>> the sqlservr.exe process is using an average of 94% of
the
>> CPU on a very powerful server.
>> Can anyone tell me how to determine what the problem is,
>> without just rebooting the server?
>> Here are some Buffer Manager statistics in case it
helps:
>> Buffer cache hit ratio 3044
>> Buffer cache hit ratio base 3048
>> Page lookups/sec 405446548
>> Free list stalls/sec 114
>> Free pages 291
>> Total pages 207872
>> Target pages 207872
>> Database pages 190592
>> Reserved pages 648
>> Stolen pages 16989
>> Lazy writes/sec 1722
>> Readahead pages/sec 477294
>> Procedure cache pages 14862
>> Page reads/sec 616224
>> Page writes/sec 658045
>> Checkpoint pages/sec 315881
>> Thanks.
>> Allen
>Turn on Profiler..
>What jobs (if any) are running? Do you have maintenance
plans executing
>that are rebuilding indexes?
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>

Runaway CPU

For some reason, for two days now, in the morning hours
the sqlservr.exe process is using an average of 94% of the
CPU on a very powerful server.
Can anyone tell me how to determine what the problem is,
without just rebooting the server?
Here are some Buffer Manager statistics in case it helps:
Buffer cache hit ratio3044
Buffer cache hit ratio base3048
Page lookups/sec405446548
Free list stalls/sec114
Free pages291
Total pages207872
Target pages207872
Database pages190592
Reserved pages648
Stolen pages16989
Lazy writes/sec1722
Readahead pages/sec477294
Procedure cache pages14862
Page reads/sec616224
Page writes/sec658045
Checkpoint pages/sec315881
Thanks.
Allen
"Allen White" <awhite_nospam@.advanstar.com> wrote in message
news:21b501c4d885$f31e0f60$a501280a@.phx.gbl...
> For some reason, for two days now, in the morning hours
> the sqlservr.exe process is using an average of 94% of the
> CPU on a very powerful server.
> Can anyone tell me how to determine what the problem is,
> without just rebooting the server?
> Here are some Buffer Manager statistics in case it helps:
> Buffer cache hit ratio 3044
> Buffer cache hit ratio base 3048
> Page lookups/sec 405446548
> Free list stalls/sec 114
> Free pages 291
> Total pages 207872
> Target pages 207872
> Database pages 190592
> Reserved pages 648
> Stolen pages 16989
> Lazy writes/sec 1722
> Readahead pages/sec 477294
> Procedure cache pages 14862
> Page reads/sec 616224
> Page writes/sec 658045
> Checkpoint pages/sec 315881
> Thanks.
> Allen
>
Turn on Profiler..
What jobs (if any) are running? Do you have maintenance plans executing
that are rebuilding indexes?
Rick Sawtell
MCT, MCSD, MCDBA
|||Thanks, Rick. No maintenance plans are running. I keep a
trace running on all my production servers and have
reviewed the trace files and can see nothing that would
cause that kind of CPU activity. (The trace captures just
Batch Complete and RPC Complete activity.) I see lots and
lots of transactions, but nothing running for long periods
of time, nor anything that would be processor intensive.
Allen

>--Original Message--
>"Allen White" <awhite_nospam@.advanstar.com> wrote in
message[vbcol=seagreen]
>news:21b501c4d885$f31e0f60$a501280a@.phx.gbl...
the[vbcol=seagreen]
helps:
>Turn on Profiler..
>What jobs (if any) are running? Do you have maintenance
plans executing
>that are rebuilding indexes?
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>

Runaway CPU

For some reason, for two days now, in the morning hours
the sqlservr.exe process is using an average of 94% of the
CPU on a very powerful server.
Can anyone tell me how to determine what the problem is,
without just rebooting the server?
Here are some Buffer Manager statistics in case it helps:
Buffer cache hit ratio 3044
Buffer cache hit ratio base 3048
Page lookups/sec 405446548
Free list stalls/sec 114
Free pages 291
Total pages 207872
Target pages 207872
Database pages 190592
Reserved pages 648
Stolen pages 16989
Lazy writes/sec 1722
Readahead pages/sec 477294
Procedure cache pages 14862
Page reads/sec 616224
Page writes/sec 658045
Checkpoint pages/sec 315881
Thanks.
Allen"Allen White" <awhite_nospam@.advanstar.com> wrote in message
news:21b501c4d885$f31e0f60$a501280a@.phx.gbl...
> For some reason, for two days now, in the morning hours
> the sqlservr.exe process is using an average of 94% of the
> CPU on a very powerful server.
> Can anyone tell me how to determine what the problem is,
> without just rebooting the server?
> Here are some Buffer Manager statistics in case it helps:
> Buffer cache hit ratio 3044
> Buffer cache hit ratio base 3048
> Page lookups/sec 405446548
> Free list stalls/sec 114
> Free pages 291
> Total pages 207872
> Target pages 207872
> Database pages 190592
> Reserved pages 648
> Stolen pages 16989
> Lazy writes/sec 1722
> Readahead pages/sec 477294
> Procedure cache pages 14862
> Page reads/sec 616224
> Page writes/sec 658045
> Checkpoint pages/sec 315881
> Thanks.
> Allen
>
Turn on Profiler..
What jobs (if any) are running? Do you have maintenance plans executing
that are rebuilding indexes?
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks, Rick. No maintenance plans are running. I keep a
trace running on all my production servers and have
reviewed the trace files and can see nothing that would
cause that kind of CPU activity. (The trace captures just
Batch Complete and RPC Complete activity.) I see lots and
lots of transactions, but nothing running for long periods
of time, nor anything that would be processor intensive.
Allen

>--Original Message--
>"Allen White" <awhite_nospam@.advanstar.com> wrote in
message
>news:21b501c4d885$f31e0f60$a501280a@.phx.gbl...
the[vbcol=seagreen]
helps:[vbcol=seagreen]
>Turn on Profiler..
>What jobs (if any) are running? Do you have maintenance
plans executing
>that are rebuilding indexes?
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>

run an external file

I am using sql server 2000 sp3a.
How do I start (run) an external file. ie, run a vbs or exe fro Query
Analyzer or from within a job step.
Thanks,
Yaniv
Within a jobstep you can choose that the type of job step is "Operation
System command", put your command in here. Another option would be tu
sue the procedure xp_smdshell which call call the commadn interpreter,
therefore you have to choose TSQL Command execution in the job step.
HTH, jens Suessmeyer.
|||Run vbs file
EXEC master..xp_cmdshell 'cscript /nologo c:\file.vbs "stringarg" 5'

> sue the procedure xp_smdshell which call call the commadn interpreter,
xp_cmdshell ? :-)))))))))
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1138186195.161343.91450@.g49g2000cwa.googlegro ups.com...
> Within a jobstep you can choose that the type of job step is "Operation
> System command", put your command in here. Another option would be tu
> sue the procedure xp_smdshell which call call the commadn interpreter,
> therefore you have to choose TSQL Command execution in the job step.
> HTH, jens Suessmeyer.
>
|||Thank you both.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23YmvfNaIGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Run vbs file
> EXEC master..xp_cmdshell 'cscript /nologo c:\file.vbs "stringarg" 5'
>
> xp_cmdshell ? :-)))))))))
>
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1138186195.161343.91450@.g49g2000cwa.googlegro ups.com...
>

run an external file

I am using sql server 2000 sp3a.
How do I start (run) an external file. ie, run a vbs or exe fro Query
Analyzer or from within a job step.
Thanks,
YanivWithin a jobstep you can choose that the type of job step is "Operation
System command", put your command in here. Another option would be tu
sue the procedure xp_smdshell which call call the commadn interpreter,
therefore you have to choose TSQL Command execution in the job step.
HTH, jens Suessmeyer.|||Run vbs file
EXEC master..xp_cmdshell 'cscript /nologo c:\file.vbs "stringarg" 5'

> sue the procedure xp_smdshell which call call the commadn interpreter,
xp_cmdshell ? :-)))))))))
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1138186195.161343.91450@.g49g2000cwa.googlegroups.com...
> Within a jobstep you can choose that the type of job step is "Operation
> System command", put your command in here. Another option would be tu
> sue the procedure xp_smdshell which call call the commadn interpreter,
> therefore you have to choose TSQL Command execution in the job step.
> HTH, jens Suessmeyer.
>|||Thank you both.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23YmvfNaIGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Run vbs file
> EXEC master..xp_cmdshell 'cscript /nologo c:\file.vbs "stringarg" 5'
>
> xp_cmdshell ? :-)))))))))
>
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1138186195.161343.91450@.g49g2000cwa.googlegroups.com...
>

run an external file

I am using sql server 2000 sp3a.
How do I start (run) an external file. ie, run a vbs or exe fro Query
Analyzer or from within a job step.
Thanks,
YanivWithin a jobstep you can choose that the type of job step is "Operation
System command", put your command in here. Another option would be tu
sue the procedure xp_smdshell which call call the commadn interpreter,
therefore you have to choose TSQL Command execution in the job step.
HTH, jens Suessmeyer.|||Run vbs file
EXEC master..xp_cmdshell 'cscript /nologo c:\file.vbs "stringarg" 5'
> sue the procedure xp_smdshell which call call the commadn interpreter,
xp_cmdshell ? :-)))))))))
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1138186195.161343.91450@.g49g2000cwa.googlegroups.com...
> Within a jobstep you can choose that the type of job step is "Operation
> System command", put your command in here. Another option would be tu
> sue the procedure xp_smdshell which call call the commadn interpreter,
> therefore you have to choose TSQL Command execution in the job step.
> HTH, jens Suessmeyer.
>|||Thank you both.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23YmvfNaIGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Run vbs file
> EXEC master..xp_cmdshell 'cscript /nologo c:\file.vbs "stringarg" 5'
>> sue the procedure xp_smdshell which call call the commadn interpreter,
> xp_cmdshell ? :-)))))))))
>
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1138186195.161343.91450@.g49g2000cwa.googlegroups.com...
>> Within a jobstep you can choose that the type of job step is "Operation
>> System command", put your command in here. Another option would be tu
>> sue the procedure xp_smdshell which call call the commadn interpreter,
>> therefore you have to choose TSQL Command execution in the job step.
>> HTH, jens Suessmeyer.
>

Run .exe

Hi, how are you doing?
Can I run a .exe inside a SP? Because before sending emails it needs to
authenticate, so I did a Delphi .exe !
MS SQL 2000
Thanks!Yes, by using xp_cmdshell. However this is a really ugly thing, and whatever is performed will
probably be lost after the scope of xp_cmdshell.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Paulo" <prbspfc@.uol.com.br> wrote in message news:ub89Zq7gIHA.3352@.TK2MSFTNGP04.phx.gbl...
> Hi, how are you doing?
> Can I run a .exe inside a SP? Because before sending emails it needs to authenticate, so I did a
> Delphi .exe !
> MS SQL 2000
> Thanks!
>|||"Paulo" <prbspfc@.uol.com.br> wrote in message
news:ub89Zq7gIHA.3352@.TK2MSFTNGP04.phx.gbl...
> Hi, how are you doing?
> Can I run a .exe inside a SP? Because before sending emails it needs to
> authenticate, so I did a Delphi .exe !
>
Yes you can do this, but don't.
There's a lot of things that can go wrong here, including xp_cmdshell
hanging and tying up resources.
And then of course there's just the time involved.
> MS SQL 2000
> Thanks!
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Run .exe

Hi, how are you doing?
Can I run a .exe inside a SP? Because before sending emails it needs to
authenticate, so I did a Delphi .exe !
MS SQL 2000
Thanks!
"Paulo" <prbspfc@.uol.com.br> wrote in message
news:ub89Zq7gIHA.3352@.TK2MSFTNGP04.phx.gbl...
> Hi, how are you doing?
> Can I run a .exe inside a SP? Because before sending emails it needs to
> authenticate, so I did a Delphi .exe !
>
Yes you can do this, but don't.
There's a lot of things that can go wrong here, including xp_cmdshell
hanging and tying up resources.
And then of course there's just the time involved.

> MS SQL 2000
> Thanks!
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html