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
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
how to tigering a sp from c#???
Answer Question | November 23, 2008 5:24 AM
C#, Stored Procedures, Triggers
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
How can I view stored procedures that have already been created in SQL Server?
Answer Question | August 6, 2008 3:13 PM
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