Search results for query: *

I have Cold Fusion code which executes stored procs and writes html files based on the results. Application works fine on my server with client's database installed. However, when the client tries to run the app - sql server actually stops and the following error message is written to the...

I have Cold Fusion code which executes stored procs and writes html files based on the results. Application works fine on my server with client's database installed. However, when the client tries to run the app - sql server actually stops and the following error message is written to the...

I am trying to write a script that effectively removes timestamp values, so that I can import data into sql server 2000 using dts. I have post this on the sql server site - to no avail, so thought I might try a different approach. Could anyone tell me what is wrong with the following code - it...

I am trying to import old dbase files into sqlserver 2000 using dts. I have 2 problems with this: 1. 1 table produces the error 'too many fields defined' - I also get this message when importing into access. 2. Many of the tables have separate date and time columns - sql server does not like...

I have successfully set up transactional replication, with the publisher running on sqlserver 2000 and the subscriber running sqlserver 7. However, I want to set up a publication with updatable subscriptions (failover queuing). The documentation that I've read suggests that this is simply an...

Could anyone advise on the most appropriate type of replication required for the following scenario? One live server and one backup server, limited no of transactions per day - 2000ish, connected on 100mb LAN. Any advise will be gratefully received. Thanks in advance. Sarah

I have a stored procedure which performs a query based on a number of input parameters. I need the resultset to be ordered by a user defined input parameter. When I pass a parameter called sort (which is the column name) and refer to it in the order by clause, the syntax checker throws up an...

I have a stored procedure which performs a query based on a number of input parameters. I need the resultset to be ordered by a user defined input parameter. When I pass a parameter called sort (which is the column name) and refer to it in the order by clause, the syntax checker throws up an...

I had a problem with some code last week, which Mike Lacey resolved for me - very kind. Unfortunately, this doesn't seem to be an end to my problem. I now need to display all units irrespective of whether there is an entry for make or drivesize. Does anyone know of a way to do this? This is part...

I need to remove the last 10 characters from a string and then display the remaining characters e.g if the string value is area-centre-servers, I wish to display only area-centre. I think that I have an idea how to do this, but cannot seem to get the syntax right. Please see the code below...

I have a number of tables from which I need to select. To try to explain myself simply, I have a table which holds data about PCs ie location, number. I have another table which holds data about each PC. However, different types of data ie IP Address, Make, Model etc are held within the same...