Search results for query: *

Thanks Terry I am just attempting (took 3 hrs and was then corrupt) to download sp2 as I am on sp1. I will install this to see if I can manage to recreate the problem. Thanks again Sarah

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

thanks jkb17 - the code seems to get a bit further now ie the error at line 12. Any further thoughts? link9 - the DTSDestination("IDateTime")is telling sqlserver to create a destination column called IDateTime. IDateTime should be the combination of the IDate and ITime values. Not...

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

solved the problem - thanks

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

Thanks for responding. SQL Server 2000. I was thinking maybe Transactional Replication with Updating Subscribers. But after speaking with someone, they have mentioned clustering maybe an option. I have read something about this but don't quite understand how it would be implemented. Would...

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

Malcolm Thanks for responding. I've tried your suggestion but the procedure seems to interpret the passed value as a string. The application (written in Cold Fusion) allows users to sort their data by clicking on a column heading. I therefore need to pass the actual column name rather than a...

Yes - but no response as yet. Thanks anyway.

Thanks for responding. Its running on SqlServer 2000 - any ideas?

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

Thanks for listening - I've sorted out my problem using views. Sarah

Malcolm Thanks for responding - I now understand that I cannot return the results required using the above code. However, I do not know a different way to resolve the problem. Is there another way to achieve my goal - which is to output all units with corresponding null values for...

My problem seems to be more fundamental than I first thought - cannot create outer join even when not using virtual tables. There are about 95 servers in the units table. I would expect to be able to see 95 entries in the returned recordset with null values in the itval column. Is it something...

SQL Server 2000. I know that Oracle is more your thing, but I live in hope. Sarah

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