Stored Procedures

Create Stored Procedure based upon existing Stored Procedure

How do I create a Stored Procedure based upon an existing stored Procedure in SQL Query Analyzer V 8.00.760

Move data in SSIS via store procedure

How do I set up an SSIS pkg to move results from a stored procedure from an external ss2005 db to the local ss2005db?

Cobol Stored Procedures

Can someone explain the flow of reentrant cobol stored procedures? Is it possible for two users to access and modify the same variable at the same time?

SQL Server project in VB 2005

A form contain two text field (Name,Address) three buttons (Save,Modify,Delete). A test.mdf file in sql server. I want total source code of that sample project Pl help me about that. Thank you prit

Calling a SQL Server 05 Stored Procedure from Oracle

Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

SQL Server equivalent of Oracle's "when no data found" exception

In a stored procedure, I'm storing the result of a select statement in @variable. Is there a way to capture a SQL Code 100, like Oracle's SQLERRM(100)/ORA-01403 if no records are returned? I'm currently setting @variable = '*' before the select and and IF @variable = '*' afterwards, but there...

Executing System Stored Procedures

What kind of "Permissions" does a developer need in order to execute sp_fulltext_catalog, sp_fulltext_column, sp_fulltext_database, sp_fulltext_table, sp_addLinkedServer, sp_addLinkedSRVlogin ?

Calling an Oracle stored procedure from SQL Server

Is it possible to call an Oracle stored procedure from SQL Server?

Difference between Sp_msforeachdb and sp_msforeachtable

In MS SQL Server what is the difference between Sp_msforeachdb and sp_msforeachtable

Catching blocks using a stored procedure in SQL

I have a stored procedure in SQL that I use to catch blocks. This stored procedure is executed by a stored procedure higher up. How do I relay the error info, if there is error info, to the parent? Do I need to use a return code or is the error info just passed back, no matter what?

Viewing created stored procedures in SQL Server

How can I view stored procedures that have already been created in SQL Server?

Replicate Stored Procedures

Is anyone aware of a tool to automate the replication of the Strored Procedures from one iSeries to another?

sp_OACreate is missing

Hi I'm trying to create a stored procedure to send mail, and 1 line in my SP states: EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT But I get an error that sp_OACreate is missing. How it happened I don't know. But how do I fix the problem? Is it possible to recreate sp_OACreate manually?...

Running a stored procedure in SQL Query Analyzer or as part of a SQL job

I have been trying to run a stored procedure in SQL Query Analyzer and as a step in a SQL job. If I run it in Query Analyzer, it takes less than a minute, but it takes considerably longer if it is run as a step. I use SQL Server 2000. Why would there be so big a difference?

Internal vs Externa Stored Procedure Performance

Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there...

Slowdown of the SAN due to overusage of temporary tables

We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. Should we...

Exporting stored procedure results into an XML file in SQL Server

I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?

Spawning additional stored procedures in SQL Server 2000

Is it possible in SQL Server 2000 for a stored procedure to spawn a second stored procedure which will not interfere or slow down the processing of the original? I need the original procedure to finish and return its output variables to the calling program before the second (whose function is to...

Ability to spawn (or fork) a sproc in SQL Server 2000

Is it possible in SQL Server 2000 for a sproc to call another sproc and then return it's output variables and close before (or while) the nested sproc processes? Goal is to nest a sproc that willl perform auditing on the called sproc without slowing it down waiting for the auditing.

xp_fileexist workd in Query window but doesnt in stored procedure

Hello, I am running on SQL server on my local PC . I am singed onto the PC using a network user. This probelm happens if the SQL server service runs as either Local system or network service. In the server management studio if I go to a query window and enter Declare @result int exec xp_fileexist...