• dba deleting data

    Is part of a DBA's job to delete production data using SQL scripts?

    Biker015 pointsBadges:
  • SQL Work Files

    In the FOCUS programming language, you can retrieve data and hold that data for further processing at some point later in the program.  What is the best technique for doing this in SQL?

    Rhansard5 pointsBadges:
  • Receiving result sets in RPG (prior to release 7.1) from an SQL SP

    I have read through the IBM manual "Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries" for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this...

    MapleLeafDeveloper5 pointsBadges:
  • Connect to remote SQL server from MySQL

    we have read only access to a remote sql server. the requirement is to read few tables from sql server and load to mysql tables (installed on Unix box). Please suggest the possible ways of achieving this.

    Nitibansal5 pointsBadges:
  • Service Broker downside

    I have service broker up and running accross 2 instances. If data is entered/updated on table A in instance A, it will send a message to the target queue and a stored procedure is used to read in the message and perform the update to table B on instance B. Once service broker is up and running,...

    Ndoan5 pointsBadges:
  • How does exchange 2010 email archiving work?

    How does exchange 2010 email archiving work? Imean techincally speaking, does it stub? What do the users see, what is on the backend, a SQL database? I can't find any articles on how exchange server 2010 email archiving works under the hood?

    Tuck15 pointsBadges:
  • What is a linear recursive query in SQL?

    What is a linear recursive query in SQL?give me an example.Is there any nonlinear recursive query??

    Gomsbk35 pointsBadges:
  • Problems running AS400 stored procedure from SQLServer 2005 SSIS execute SQL task

    I need to run a stored procedure (with two input parameters ) that has no output, on an AS400. When I try using the IBM DB2 UDB for iSeries IBMDA400 OLE DB provider, I get the following error [Execute SQL Task] Error: Executing the query "CALL TPSDTA50GQ.PMCTESTTP('PETER', 4)" failed with the...

    PeterJC15 pointsBadges:
  • SQL problem: Adapting code fragment

    How do I adapt the fragment of code below to show: a) Two columns - the Filipino Population and the Total Population  b) The Filipino Population as a percentage of the total population  SELECT DISTINCTROW POPDATA.CITYNUM,  COUNT(*)FROM POPDATA  WHERE POPDATA.ANCNUMBER=720  GROUP BY...

    Mentos5 pointsBadges:
  • Database Security: SQL Server 2005 security login

    Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me..........

  • Using mdf file in website

    When you've developed e website with vis stud, including an aspnetdb.mdf file and a database file for the webcontent, how can you use these mdf files on the isp server where sqlserver 2005 is running? A normal connectionstring in the web,sonfig file gives an error about the attachdbfilename being a...

    Makoe5 pointsBadges:
  • Updating SQL express to SQL 2008 R2 on server 2008 with sharepoint 2007

    At present we are running a Windows 2008 Server which has Sharepoint 2007 installed and houses our exchange server.  Apparently only the Express version of SQL server was installed initially and now the 4GB database limit is affecting our intranet. Have been advised that we need to update to SQL...

    Weboneau5 pointsBadges:
  • Are parameters permitted on SQL Server 2000 views

    I think the answer to this is NO, but is there a way to create a view that accepts input parameters? I created the view hard coding in something that now needs the flexibility that a parameter would provide, but I've never seen a parameter on a view - Is it possible? Thanks

    CO Bill120 pointsBadges:
  • Recovering data from crashed database

    i   i have a question. my database  is crash .i don't have present backups.but i'm having  last week backups.  and  backup  strategy sunday   10 p.m  full backup everyday  1 p.m    differential backup every one hour transaction log backup  please give me reply as soon as thanks &...

    Venkatdbait35 pointsBadges:
  • Microsoft Retail Management System and SQL Server “Write” error

    I am running Microsoft Dynamics Retail Management System POS 2.0 on Microsoft XP platform.  Store Operations Administrator and Manager are working with no problems.  I know I am networked properly.  When I open the POS I get the following:  "Open-Incorrect Function", I can click OK and sign on...

    Cls5 pointsBadges:
  • Importing large sets of Excel 2000 data to SQL database

    I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?

    ITKE342,860 pointsBadges:
  • SQL Server 2005 & 2008 on a Cluster in Production

    Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because...

    Lorisj3325 pointsBadges:
  • ASP Web page database?

    I want to do a web page with ASP.NET I already make another one using Access as my database manager but now is a bigger project so I want to know what can I use for create the database or if it's good still with access. (I Know basically  "everything" is SQL but please give me a good...

    Eddy20 pointsBadges:
  • Error when translating execute immediate from Oracle to SQL

    SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = 'Avi' /* * SSMA error messages: * O2SS0013: EXECUTE IMMEDIATE statement was converted into EXEC(...) statement,...

    Ariel5 pointsBadges:
  • Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?

    Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?

    Keck5 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