The following error message occurs when I attempt to backup with SAP transaction DB13: ***************************** SQL Job information ****************************** Jobname: SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326] Type: TSQL DB-Name: RPD For Run: 20090620 09:43:26 **************************** Job history information ***************************** Stepname: CCMS-step 1 Command: declare @exeStmt nvarchar(2000) exec rpd.sap_backup_databases @dbList= “master,RPD”,@r3Db=”RPD”,@bDev=”R3DUMP0″,@expDays= 27,@jobName= “SAP C…

I need to manipulate xml-files larger than char-field max-length allowed with RPG.   [strong]Background info:[/strong] My current solution uses a char-field… My app stores XML-files in CLOB-fields. I copy the xml-file from CLOB-field to a char-field: I then use %scan to find relative position of the string to be replaced, which is done using the…

How do you synchronize of SQL Server 3.5 Compact Edition to SQL Server 2008? I have the framework installed, do I have to create a third party application to actually perform the synchronization?

how to update a row in grid view in vb.net using sql server as back end

We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately when removing a SQL trigger…

I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version…

I have created several extended stored procedures in SQL 2008 which when i run always return a NULL. I call these XP’s from within a stored procedure. They work fine in SQL 2005 and SQL 2000. One thing i have noticed is when i click on the properties of the xp the path to the…

Is it possible to use a variable in the label-string of the LABEL ON sql statement so that the variable can be changed dynamically in an SQLRPGLE program ?

Hi, I have a SAP PI 71. scenario where I need to call a Web Service exposed by an SQL Server 2005 app running on widows 2003. The SOAP adapter call fails with an HTTP 505 indicating mismatched HTTP versions. it appear that sap is speaking 1.0 and sql server is speaking 1.1. Do you…

Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a…

Using a linked server I can’t seem to execute an Oracle SP from SQL. The Oracle SP requires 5 parameters and returns a cursor to a record set. The error I get suggests a syntax issue. OLE DB provider “MSDAORA” for linked server “PASSRPT” returned message “Syntax error in {resultset…} ODBC Escape.”. Do I need…

We are in the process of developing an electronic email newsletter system for one of our client. Could you tell me how we may be able to link to and from their Microsoft CRM database to our email newsletter SQL Server database. For example, we need to link the newsletter with the database of contact…

reports will not work after I enabled drill downs (v.2.6) Followed directions and enabled drill downs.  Now, reports and drill downs will not work after the day I reset the drill down.  Checked directions and no indication of making changes anywhere other that the configuration menu in surfcontrol UI.  Do I need to reset something…

Can any one please tell me how to know the current password of my pl/sql developer which i am using currently? I know my product code and serial Send me the procedure Thanks in advance PSR.COM

I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few…

Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three tables where…

Need a update in SQL comparing two tables check description and if equal to blank then match keys on master update blank desc. field with master desc field. UPDATE mbmtest01/wbmscur  set spdesc = itdsc  from amflib7/itemasa  where spdesc = ‘ ‘ and itnbr = spptno Keyword FROM not expected. Valid tokens: [end-of-statement][/end-of-statement].

when i start debugging project,sql connection will be closed,before that it will be open .Iam using sql which comes along with vb.net 2005.Iam using sqlconnetion in login form also there its not giving error when i used sql connetion code in another form its giving error login failed .iam tried up of this error.plz help