• 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:
  • Free IT Book: Demystifying the Virtual Desktop

    Interested in desktop virtualization? This week's free IT book is just what you need. Michael Fox's Demystifying the Virtual Desktop Starting with Desktop Virtualization is a quick read that breaks down the business and technical complexities of virtual desktops. Simply answer one of five questions...

    ITKE346,360 pointsBadges:
  • Exchange 5.5 in a Server 2003 AD Domain

    My company is planning an upgrade of our nt4 PDC's and BDC's to server 2003 standard. We have three different sites and currently our main site has a PDC and the remote sites of BDC's. We are planning to implament 3 new 2003 servers. One here and one at each of our remote sites. The one question I...

    Hamel010 pointsBadges:
  • New Data Field in Stored Procedure

    When I add a new data field in a Stored Procedure, how do I make the new field available to the Crystal Report?

  • deleted the database how to recover it?

    Hi ,actually i know importance of back up, but i dont have the back up in any-how condition. accidently the databse deleted by me .how to recover it ? how to use the transaction.log file to restore deleted database in sql srver 2005

    Lalit35 pointsBadges:
  • Installing a named instance using another edition’s installer.

    I have a SQL Server 2005 standard edition installed with a default instance. I need to install an additional named instance. However I could not find the standard edition installer CD; and my colleague managed to dig out a copy of the Express edition installer. Can i use the Express edition...

    Tamtam5 pointsBadges:
  • Defrag SQL Database

    To my understanding, a normal defrag application will not defrag a SQL database. How would this be done, how would you defrag a SQL database? What applications could you use and/or what commands would you use? Kind Thanks.

    CyberJ0 pointsBadges:
  • Load balance of SQL database

    When my database has grown beyond the performance capabilities of a single SQL Server, what are the ways get increase the system performance?

    RASHMIMB15 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