Search results for query: *

I have an issue and I am hoping some people can help me out. I need to export certain information from SQL to an XML file for FTP to be then imported into another SQL database. I found some documentation on the web but it does not seem to be right. My data is not complete and I can tell I am...

What I have to do is take data from a SQL View, then use a ddf file, then create the report. Pretty straight forward at first. Here is where my problem lies. Since I cannot use unions in a view and that is what the software looks for that is out. I was able to get the desired result using...

I need to write an app that basically looks for a running process on the network and then if it doesn't see the process running for "x" amount of seconds to start an application locally. I know how to write the "timer" and to call the app but I do not know how to have it look for the process...

Is it required for SQL to run on port 1433? I was wondering b/c I want to change the port that is used to try and not make it too easy for hackers. I have to remotely connect through VPN to other SQL servers from my main server. Just looking for some security measures I might be able to get...

I need to find the best way to either copy or "update" a database through a network so both databases are pretty much mirrored. Here is the catch, the production systems will be running MSDE. I have SQL 2k Developer so I can build it there, generate a script, and then update MSDE. I just do...