Search results for query: *

This query would be setup on a timed job. I suppose if I needed to I would write an application to do this but was tryingt o avoid that.

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...

As I said previously subreports will not work in the third party application. Looking for another way other than using subreports. I already have one created using subreports but does not work in the application.

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...

Do you know of a good resource that I could use to learn how to write something like that?

I know typically in the computer world there are rules that can be bent if you know how to bend them. Just curious if this is one rule that can be bent.

Is there any way to work around MSDE not able to be a publisher for transactional replication? That would be ideal for what I need to do.

Thank you very much. It wasn't too long after I posted this I tried replication. I am actually testing that tonight on MSDE to see if I can get it to work. As far as mrdenny ... to answer you. The primary needs to write to the secondary in case the primary fails. I just need to come up w/...

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...