• SQL 2005 Database Compare

    If there a way to compare two similar database to find where a Stored Procedure is different between the second database. Different in it not there or the Create Date or Modify Date is different?

    SQLNovice15 pointsBadges:
  • 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...

    Baron4005 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • When submitting a procedure via CL program, i do not get any abnormal end message.

    When submitting a procedure via CL program, i do not get any abnormal end message even though the procedure has not not completed normally, is there anyway by which we can find the cause of the failure of the completion of the procedure normally.

    JohnsonMumbai1,160 pointsBadges:
  • iseries stored procedure : read character string containing single apostrophe …. ex: Let’s

    I am working on a stored procedure that requires a literal string to be input into a VARCHAR(1024) variable. My stored procedure has no problem reading the word........... Let''s However, if I try to read the word............Let's, I get a code violation. Do I need to read the string as a datatype...

    Dsthornton5 pointsBadges:
  • Msg 102, level 15, State 1, Line 102

    I get this with an 'Incorrect syntax' messasge when I run a stored procedure. if I run the 'offending' code in isolation it works fine. If I tidy the code (e.g. remove line feeds etc), the error 'moves' to a different location. HELP!

    TonyDyer5 pointsBadges:
  • Where did the undocumented stored procedures go in SQL Server 2008 Managment Studio?

    Is there a way to see the undocumented stored procedures in SQL Server 2008?  They don't seem to show up in the explorer tree in Management Studio the way they did in SQL Server 2000's Enterprise Manager. I was able to run XP_FIXEDDRIVES but it doesn't show up in the list under stored procs in the...

    Brenbart5 pointsBadges:
  • How to pass a store procedure and a variable to a datagrid

    I am a newbie when it comes to passing parameters to a control. I am programing in VS 2008 using VB as the language. The grid is in an ASP.Net (3.5) page  I have set up a store proceduer in SQL Server 2005 as follows: CREATE PROCEDURE   usp_selEmpSSN--Transfer all records from tbl_CL with the...

    Neilo125 pointsBadges:
  • RPGLE external stored procedure when called with OUT parameter having issues when called from C#

    We have created some stored external procedure with paramter type OUT but these were giving memory protection at C# side.However when we call it from operation navigator ,it is running succesfully.I created some SQL stored procedure with OUT paramteres and these were working correctly when invoked...

    Arush5 pointsBadges:
  • Writing a stored procedure across two databases

    I currently backup our live databases and restore them into a QA environment. This doesn't cause a problem with our stored procedures as they have all been written without hard-coded database names.

    SQL Server Ask the Experts2,585 pointsBadges:
  • passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases.  I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables.  Also we are not allowed to use the...

    LL12325 pointsBadges:
  • 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...

    ITKE346,360 pointsBadges:
  • Msg 102, level 15, State 1, Line 14

    Hi, I'm ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the 'ON' on the line "SET ANSI_NULLS ON". Could you please help me? I can't see what's wrong. Here's my code:  CREATE PROCEDURE InsertDBTables  AS  BEGIN  SET NOCOUNT...

    MasterK15 pointsBadges:
  • How to encrypt a big list of sp’s at once

    I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn't be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I'll like to know if there is a way to do...

    Grizo5 pointsBadges:
  • Stored procedure content

    Is there a way to "retrieve source" on a Stored Procedure ?  I need to find out what 2 of our Stored Procedures do - especially what programs thay call. Of course, no documentation and no methodology for source-based creation.  

    aceofdelts1,930 pointsBadges:
  • AS/400 stored procedures

    Is there a way to list the existing stored procedures on our box ? Those that wrote them are gone and documentation is sketchy. We found some by using any SQLRPG source as a clue but none of these were "create" routines (some were actual procedures). Seems like there ought to be an easier way.

    aceofdelts1,930 pointsBadges:
  • Create a Stored Procedure using CL and RPGLE programs

    I have an RPGLE program called from a CL program for database files overrides. I want to call the same programs from a stored prodecure on SQL Server from within a Web application. I am brand new to SQL Server but am pretty good on the AS400.

    NCharette20 pointsBadges:
  • execute as with synonym

    This is a good one, I have a stored proc in database A that first deletes some rows from a table in database A. it then does a delete from a synoym that references a table in a different database. We were trying to use a "execute as" with a windows sql account "domain\srvc" that has sysadmin...

    tcstl95 pointsBadges:
  • Using Oracle 10g Stored proc in SSRS 2005

    I'm trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run...

    Ala10ala15 pointsBadges:
  • Error inserting into table with identity column

    I have 2 stored procedures. Both insert records into table variables, and each of those table variable has an identity column. One procedure executes and the other gives an error telling me that I am explicitly trying to insert into the identity column (which I'm not). Here is the code from the 2...

    Bleeb45 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following