Recent content by sarahw

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