Search results for query: *

What is the easiest way to keep a setup of local table in sync with views on a remote server to which I have limited access? Thanks in advance!!!

I need to migrate current mail and accounts from one Qmail server to another. Do I just need to rsync /var/qmail/conrol and /home/vpopmail and switch the DNS? How do I forward messages that still go to the old server after the new one is online? What else do I need to be aware of? Thanks!

I'm migrating a web app from MSSQL server to Postgres and I've encountered a strange problem I can't seem to get around. I export the data from my Microsoft server to a text file, everything work flawlessly with the exception of the image columns. It seems as though when the data is exporting...

I'm migrated a webapp from MSSQL to Postgresql and I'm having some problems with the store procedure. This is what I have so far, but it doesn't seem to be working. What I need to do 1.) Get the visitor_id I want to check to see if the current cookie is associated with a visitor_id, if the...

Each time a page is viewed on my website, the time, session, url, and refferer are recorded. I'm trying to analyze this information to make some sense out of it. I've managed to accomplish almost everything I'm looking to do except for the following tasks. This is the table structure...

Here's my table structure; idxmls1 - the data on the remote server ------ id etc.... ToDownload - a list of id numbers I need to download ---------- MLS Here's the query I'm trying to execute to generate the data from the remote server. The query executes without any problems, however...

I'm working on a stored procedure that will split up an image into a bunch of different columns so that I can display images using a php script. This is necessary, b/c php will only return 255 characters per field. I've been able to sucessfully generate the sql query, but it isn't executing...

I tried writing a sql script to create my database. Is is possible to use variables in the CREATE DATABASE command such as I have done below? I've been getting some errors and haven't determined if this usage is allowed. /* define variables for this script */ DECLARE @DBFilePrefix...

I have a Windows 2000 server running routing and remote access and server as a NAT router providing internet connectivity to an internal network. When clients connect to the local network using VPN they loose the ability to connect to the internet. The clients are Windows 2000 or Windows XP...

I've setup a zone on my Windows 2000 Server for my domain, but I haven't been able to determine how to setup a catchall, alias, or wildcard dns record. I'd like to direct whatever.domain.com to www.domain.com without explicitly creating a new cname record for whatever.domain.com. Essentially...

I have a table with some property information, another table with some more information about those properties, a table which contains the relationships between media files and properties and a table to contain media. When I use joins to get the information I'm looking for I return more rows...

I have 4 tables: 1.) property - contains property listings (i.e. address, price, city, state, etc); pid is an int and the primary key 2.) property_ext - contains more information about the property (i.e. a long description, etc); pid is an int and the primary key 3.) media_rels - contains...

Is is possible to insert in a manner similar to that shown below? This query won't run; however it shows approximately what I'd like to accomplish. INSERT INTO [agentmaster].[dbo].[property] (property.bath_level, property.bath3_4_level, property.baths, property.baths3_4...