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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2006-01-19 : 08:35:31
|
| Tugrul Guclu writes "Hi , We have a single board computer with XP Pro , SQL Server 2000 , .Net Framework installed. But there is no monitor , Mouse or keyboard. We record incoming data from serial port to sql server by stored procedures. Since there is no monitor-keyboard-mouse all we can communicate with PC is USB port. When user plugs a USB device , appliation in C# automatically recognizes USB device and a transforms collected data from sql server to an xml file by WriteToXml method. Here are my questions1-Is there another way of deploying it in USB by SQL Server tools? Like using a views/defining a job or something ? Because using XML for this job slowes down the PC and sometimes it takes very large file sizes when carried by XML( > 500 MB) 2-What is the minimum configuration of SQL Server that occupies less disk space and RAM ? Is there a client tool or something ?Thanks in advance" |
|
|
|
|
|