Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
djmack
Starting Member
8 Posts |
 Posted - 2004-04-06 : 18:00:06
|
| Hello All,I have created a simple copy file extended stored procedure that takes an input file and copies it to an output file location.I have an evaluation version of SQL Server 2000 running on my machine and I tested the extended stored procedure on this server and it works fine.When the DBA added this XP to the SQL Server containing the database I need to use it with it does not copy the file over to the output location but does report 'The command(s) completed successfully.' in query analyzer.Anyone have any ideas what I might be doing wrong? Thanks in advance for any help.DM |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-06 : 19:27:48
|
| The account that is running the procedure has to have access to both file locations. If not, the procedure will fail.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
djmack
Starting Member
8 Posts |
Posted - 2004-04-07 : 10:03:36
|
| The account does have access to both file locations. I created the DLLs used in the stored procedure in VC++.net, which is on my machine on not on the server. Could the problem possibly have to do with that? Or maybe the SQL server does not have some of the libraries used in the DLLs.I am new to VC++ as well as SQL Server so I apologize for my ignorance.Thanks for the reply,DM |
|
|
|
djmack
Starting Member
8 Posts |
Posted - 2004-04-07 : 10:39:54
|
| Could it also be that the SQL Server needs to have the .net framework installed?Dm |
|
|
|
|
|
|
Extended Stored Procedures