Search results for query: *

I have defined an 'image' column for this. I am using active server pages via an IIS4 web server, not a VB application...I think a VB application would have been easier, but using a web-based approach (no choice) I am relying on using FileSystemObjects for my file handling, which is ok as it is...

I am currently required to upload a file via an ASP webpage to a server and then save that file to a SQl Server 7 table. Currently, the file upload is working fine and we are saving the uploaded file to a directory and recording the file name in the database. This part works really well, BUT...

Hi all, I agree with your comments about sharing how it is done. I am still reviewing this subject and when I have decided on how to implement it at this location, I will pass on my experiences. It won't be quick as my boss has got me doing other things first and I'm doing this as I can....in...

Thanks all, I will take foxdev's advice and look at snapshot replication as it only needs to run once a day for out purposes and the servers are currently not under any pressure during the 'wee dark hours'. Good luck with your efforts, christine1 waggers

I am trying to determine the best way of automatically synchronising databases using SQL Server 7.0 We have three servers all using the same database - one is used for development work, a second is used for development and pre-production testing and the main machine is the production server...

TomasDill, I have tried this approach but the recordset is apparently being closed before I can reference the returned value. The code I am using is... sql = &quot;INSERT INTO <table-name> (<fields>) VALUES (<corresponding values>) SELECT @@IDENTITY as ID&quot; SET rs_XXXXX =...

I don't seem to be able to get any value returned - although it works well is query analyser. How do I address a returned value from such an exercise?

We are inserting records into a SQL Server 7.0 table and are needing to be able to determine the identity value used by the system. @@IDENTITY appears to be the way to go but we are not able to place this value into a variable when it is called from a ASP page. I would be grateful for any...

We are using SQL Server 7 and one of it's features is the ability to email alerts to operators when automated processes fail or experience problems. The concern is that this requires an account to be created on the Exchange server for SS7 to be able to send the email. This account requires...

Chris, All of the stored procedures that I have created using 'nested cursors' have all performed horribly. By nested cursors I am talking about cursors inside cursors using loops etc. In short, to get acceptable performance I got rid of all of them and re-engineered all my sql statements to...

Problem solved. I created a clustered index and the whole sp now runs in approx 3 seconds. waggers

I have created a cursor in a sp that is causing me some problems. If I run the select statement(only) in Query Analyser I get a nil result in approx 1 sec - this is fine! But if I create the cursor in QA or in the sp, everything is still fine until I issue the 'open' command. Opening the...

I am trying to run an automated job from SQL Server that will run a number of stored procedures and then create a static HTML file based on the results. Does anybody know how to write to a text file from SQL Server - I am aware that this can be done using ActiveX scripts but how do I get one of...