Search results for query: *

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

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

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

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