• CL/QMQRY

    i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it...

    Sanashakeel15 pointsBadges:
  • Recovering .mdf and .ldf files from SQL Server

    I backed-up our SQL Server yesterday around noon, and we then added more data in. Today, when we tried to start our application, we found that the database is in SUSPEND mode. We stopped our SQL services and tried to copy the newer data, but there was a data error. It seems that our .mdf file is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal 8.5 export trouble

    My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report)...

    Sam45 pointsBadges:
  • SQL Query

    how to select only those table name from database that have a two field in table like PID amd EID table that have PID also have a EID in a single table those table i want to select

    SDN15 pointsBadges:
  • Getting SQLCODE -518, while running EXECUTE Statement after PREPARE Statement in COBOL

    I am executing a dynamic SELECT query (No CURSOR- Normal SELECT) WS-STRING - SELECT MEMBNO FROM ENBMAS WHERE MEMBNO = "3535"  EXEC SQL                                     PREPARE SQLSELX FROM :WS-STRING...

    COBOL400Praveen30 pointsBadges:
  • Recovering the MySQL database

    In the process of editing my database, I accidentally deleted the MySQL database. I thought I recovered it, but when I opened MySQL Query Browser, it was not there. Is there an easy way to recover it for good?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error on Transaction log Backups

    Getting error -1073548784, when trying to run a backup of transactions logs ( SQL SERVER 2008, STD ed). Can anyone help?  

    SQLGUMBO5 pointsBadges:
  • Scrip an select from linked Oracle database in Management studio gives multiply fields

    In SQL Server 2008 R2 Management studio under Linked servers I want to script a select from an Oracle database table. The result is that many of the fields occur three times. What can the reason for that be? See this example: SELECT [RATETYPE],[RATETYPE],[RATETYPE]            ...

    AnnaLena5 pointsBadges:
  • Changed Foxpro 2.6 .dbf file and change doesn’t show up when I run the .exe

    Hi, I am hoping I am posting this in the correct forum. I work for a company that is running a simple tickets database program to track who uses what sports tickets. There is a .exe file and a few .dbf files, etc. About 10 files in a folder to run this Tickets program from Dos FoxPro 2.6 version....

    Djr6004135 pointsBadges:
  • Compression in SQL Server 2008

    how can i use compress backup option  in sqlserver 2008r2 

    Sanjaygutta5 pointsBadges:
  • How to add two timings in SQL Server 2008

    DECLARE @TIME1 VARCHAR(10),@DURATION VARCHAR(10) SET @TIME1='10:00' SET @DURATION='00:25' SELECT CONVERT(TIME(0),@TIME1)+CONVERT(TIME(0),@DURATION) I need to add two timings ...suppose if the @time1 is '10:00' and the duration is '15' mns then it should show 10:15 ... Any help highly...

    Muralihan5 pointsBadges:
  • SQL 9010 Error when using RUNSQLSTM

    I have a CL program having the following RUNSQLSTM RUNSQLSTM  SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK)            COMMIT(*NONE)                            AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE...

    MaldaTabbah5 pointsBadges:
  • How to connect my computer to SQL server 2005

    I need your kind support in connecting  my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards.. 

    Biggner10 pointsBadges:
  • conversion of SQL Server 2008 stored procedure to Oracle 10g

    Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g

    Oracle10gSQLserver20085 pointsBadges:
  • Cannot INSERT data into table with identity column

    In my program I have an EmployeeRegistry table which holds data of each employee's work attendance. Every attendance record is uniquely distinguished by an IDENTITY COLUMN called "AttendanceID" which has an IDENTITY SEED of 1 and an IDENTITY increment of 1. However when I try to insert an...

    Obhasha0795 pointsBadges:
  • SQL trigger on column

    Table have delete and update trigger. How to identify which columns are affected by this triigers? or  which column have  triggers ?

    Lkjh123415 pointsBadges:
  • Restoring a SQL database with an .mdf file

    How can I restore a SQL database with an .mdf file?

    SQL Server Ask the Experts2,585 pointsBadges:
  • table size strange in SQL SERVER

    Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl](     [IdUrl] [Int] IDENTITY(1,1) NOT NULL,     [IdSupply] [Int] NOT NULL,     [Url] [varchar](512) NOT NULL,     [UrlCod] [varchar](256) NOT NULL,    ...

    ens1z10 pointsBadges:
  • Access and sql server wide tables

    Does anyone know how to access sql server wide tables using Access

    Johnatsteeltorchdotcom5 pointsBadges:
  • Creating New Data Source to SQL Server…

    I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I'm choosing "Add...", then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some...

    ITTinker5 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