Strange Stored Procedure Behavior (Dev vs Prod)
I have a stored procedure that runs on my Production database in 0.394 seconds. However, when I try to run the SP on a DEV box it takes well over 15 minutes to run *every* time. I have checked indexes and everything seems to be identical (I did a backup/restore to the Dev box in [...]

Answer Question   |  November 3, 2008  9:01 PM
SQL Server 2000, SQL Server 2005, SQL Server Query, SQL Server stored procedures, Stored Procedures

Spooling Oracle Output via SQL DTS
I am able to execute a stored procedure that resides in a database on an Oracle server via a DTS Package on a SQL Server. I would like to be able to spool the output to a .log file on a different server. Is this possible using DTS?

Answer Question   |  October 16, 2008  4:09 PM
DTS packages, Oracle, Oracle Output Via SQL, SQL Server, Stored Procedures

Triggering a stored procedure from C#
how to tigering a sp from c#???

Answer Question   |  November 23, 2008  5:24 AM
C#, Stored Procedures, Triggers

Creating a stored procedure in SQL
I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?

Answer Question   |  April 8, 2010  6:50 PM
Parameters, SQL, Stored Procedures

SharePoint profile import error
When performing a full or incremental profile import, I always get these three errors in the event viewer: A runtime exception was detected. Details follow. Message: Could not find stored procedure ‘proc_ar_BumpCacheInvalidationCounter’. Techinal Details: System.Data.SqlClient.SqlException: Could not find stored procedure ‘proc_ar_BumpCacheInvalidationCounter’. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at [...]

Answer Question   |  December 21, 2009  2:11 PM
MOSS, MOSS 2007, SharePoint, SharePoint profiles, Stored Procedures

How can i connect DB and input values in stored procedures using VBA
hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me….

Answer Question   |  September 23, 2008  6:41 AM
DB2, Stored Procedures, VBA

Creating stored procedures to execute tables at runtime on a SQL Server
I’d like to execute different tables at runtime on my SQL Server by creating stored procedures. This is the syntax I am attempting to use: “create procedure sp1(colname varchar(400), tab_name IN varchar2) AS BEGIN select * from ‘@TABLENAME’ where CompanyName=’@COLUMNNAME’ end” Is this syntax accurate, and if not, how could I create this stored procedure?

Answer Question   |  September 18, 2008  7:21 PM
SQL Server stored procedures, Stored Procedures

Setting aside code for 12 databases in separate database on SQL Server
I have 12 databases on my SQL Server, one for each month of the year, and I have almost all the same stored procedures in each database. This architecture is hard to maintain, because you have duplication of the code, and a modification must be made on all the databases. Is there a way to [...]

Answer Question   |  September 9, 2008  8:23 PM
SQL Server, SQL Server database, 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

Answer Question   |  September 8, 2008  6:31 PM
SQL Query Analyzer, SQL Query Analyzer 8.x, Stored Procedures

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?

Answer Question   |  September 5, 2008  10:14 PM
Import external data, SSIS, Stored Procedures

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?

Answer Question   |  August 29, 2008  9:47 PM
COBOL, COBOL stored procedures, Reentrant COBOL, Stored Procedures

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

Answer Question   |  January 23, 2011  5:05 AM
SQL Server, Stored Procedures, VB, VB 2005, Visual Basic, Visual Basic 2005

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!

Answer Question   |  January 16, 2009  7:20 AM
DBLink, Oracle, Oracle stored procedures, SQL Server 2005, SQL stored procedures, Stored Procedures

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 must be a more elegant [...]

Answer Question   |  March 6, 2012  2:41 PM
SELECT statement, Stored Procedure variables, Stored Procedures

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 ?

Answer Question   |  August 13, 2008  2:56 PM
Developers, Permissions, Stored Procedures

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

Answer Question   |  May 10, 2010  3:59 PM
Oracle, SQL Server, Stored Procedures

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

Answer Question   |  August 22, 2008  7:00 AM
sp_MSforeachdb, sp_MSforeachtable, SQL Server, SQL stored procedures, Stored Procedures

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, [...]

Answer Question   |  August 6, 2008  3:16 PM
SQL, Stored Procedures

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

Answer Question   |  August 6, 2008  3:13 PM
Stored Procedures

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

Answer Question   |  August 1, 2008  12:50 PM
iSeries, Stored Procedures