Recent content by 13415

Hi We are running SQL server 7.0 on windows NT server. We want to automate the run of a stored procedure once a unix script completes on unix server. Please help in this. Thanks

We are running SQL server 7.0 on windows NT Server. We need to automate the run of a unix script on a unix server as soon as the run of stored procedure completes. Please let me know the best possible way to schedule this , because we can't use Cron in this case. Thanks

Thanks for responding. By permanently caching we can expect performance gain. execution plan will not be generated. it will save time. thanks

Hello We have a weekely batch job which transfer date from SQL server 7.0 to Oracle datbase. This consist of 15 stored procdedures and one master procedure which calls each procedure one-by-one. We want to pin the execution plan of all these stored procedure to into SQL server memory , so...

I am using linked server to transfer data from SQL server to Oracle database. Transfer is really slow. I want to shift to DTS , how can we use stored procedure inside DTS. Can be put data from a temporary table inside the procedure to oracle tables using DTS

I AM USING LINKED SERVER TO POPULATE ORACLE DATABASE FROM SQL SERVER 7.0. INSERT IS TAKING MUCH MORE TIME THAN NORMAL ORACLE INSERT PLEASE LET ME KNOW , HOW CAN I IMPROVE THE PERFORMANCE OF LINKED SERVER. THANKS

Hi We are usuing linked server in SQL server 7.0 to populate Oracle database. It is taking very high time as compared to directly loading data in oracle tables using flat files. SQL server and Oracle database are both on same Switch. How can be be improve the performance of linked server ...

Thanks a lot , but this article don't discuss how to handle unknown errors inside a stored procedure. The first article mainly discuss how to customize error messages. second article deal with error handling from client. I want to know something wich i can use in all error condition.

Hi How ,we will handle all unknown error which may come at run-time in SQL server stored procedure. We can't use SET_XACT_ABORT ON option. Because it will not allow to capture the error message. What is the best way to for error handling in SQL server 7.0 stored procedure running s a batch...

I want to asssign the error messages generate inside the stored proedure to a local variable. Please suggest some way. Here is an example SELECT * FROM ThisObjectDoesNotExist Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'ThisObjectDoesNotExist'. SQL server will show this...

[b] I want to send an E-mail after the success or Failure of my Batch job ( Stored Procedure) which should have a text file attachment. How it can be done? Please help.

I want to generate a text file (or insert into a table) of all errors generated inside my stored procedure. This is urgent, please help.

I want to assign the error messages generated inside a stored procedure to a local variable . How it can be done? I am using SQL server 7.0 Again what is the best way to handle the unknown errors?

hi I am using linked server for populating oracle tables from SQL Server 7.0. But i am unable to manage the transactions. Even the procedure gives runtime error it partiaaly commit data. My requremnet is that if SQL server stored procedure gives run time error it should not commit any data...

Hi I need to create text file in SQL server 7.0. My requirment is to select data from two or three tables then concatenate some of the fields with each other and with some constant and the create a text file. When i am using DTS it is only giving query option to run. What are other means to...