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 |
|
langkew
Starting Member
5 Posts |
 Posted - 2004-08-30 : 15:18:43
|
| In a VB program, I found i can upload a binary file to the disk of sql server with 'sysadmin'. I want know how to do like this. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-30 : 15:24:40
|
| What does sysadmin have to do with uploading files to SQL Server? And by binary file, do you mean images? If so, that is not recommended to be stored in a database.Tara |
 |
|
|
langkew
Starting Member
5 Posts |
Posted - 2004-08-30 : 15:42:54
|
quote:
Originally posted by tduggan
What does sysadmin have to do with uploading files to SQL Server? And by binary file, do you mean images? If so, that is not recommended to be stored in a database.Tara
Some SQL Servers deleted or renamed xplog70.dll, so xp_cmdshell is not availiable anymore. i want upload a new copy of xplog70.dll and reactivate xp_cmdshell, is this possible? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-30 : 15:45:34
|
| If the DBA deleted it, then you probably should not readd it. Have you talked to him/her? You probably can just copy the file into the directory then register it.Tara |
|
|
|
langkew
Starting Member
5 Posts |
Posted - 2004-08-30 : 15:59:10
|
quote:
Originally posted by tduggan
If the DBA deleted it, then you probably should not readd it. Have you talked to him/her? You probably can just copy the file into the directory then register it.Tara
Thanks for your answers, i'm a chinese and cannot speak very well in english and do not know how to deliver myself of great appreciation. In the future i will often come to this forum because i can study plenty here. |
|
|
|
|
|
|
Upload a binary file to disk with sysadmin?