• Database file in Novell GroupWise

    What is a data base file in novell groupwise? Is it associated with each novell file or there is only 1 which contains info for all other file?

    PCVITA15 pointsBadges:
  • How to perform pit recovery

    I cannot find a good doc which describes hot to perform a pit recovery in sql server.

    Michaelkurth5 pointsBadges:
  • Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM?

    Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE350,945 pointsBadges:
  • Archiving Exchange 2007 in a SQL database

    How do you set up an SQL database/server to receive and store archiving/journaling for exchange 2003/2007 email.

    Cmoney5 pointsBadges:
  • Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE350,945 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Free Centralize backup solution

    Hi, anyone has idea of any freeware centralize backup solution or low cost best centralize backup solution. i have 12 lcoations with File and print servers. SQl server Database server 2 web serevrs 1 Domain controller i want to backup the files at my central IDC. locations backup has only Excel,...

    Thmohan50 pointsBadges:
  • VB.NET – Can’t insert data into database.

    I used insert command it worked successfully that your data has updated.But it is not showing in the database. Please look in the below code and tell me where I'm wrong: Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization Imports...

    Shaz255 pointsBadges:
  • Convert from MS Access to SQL 2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • Consolidating SQL Server databases

    How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting VB 2008 to SQL Server2005

    How to connect VB2008 with SQLServer2005 through coding. Not through OleDBAdaptar. Also Let me know the code for Add,Edit, Delete & Save in VB2008

    Ishita20095 pointsBadges:
  • Backup Performance Compare

    How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.

    Michael Tidmarsh31,855 pointsBadges:
  • How to use databases made in Access or Excel in SQL

    How can I use databases made in Access or Excel in SQL? I'm trying to import readymade databases in SQL.

    Dragan1525 pointsBadges:
  • How to use INSERT or UPDATE on SQL Server

    In our SQL Server database, we have a table structure like this: MyTable(KEY, datafield1, datafield2...) Sometimes, we need to either update an existing record or just insert a new one if you doesn't exist. Basically, this is what we want to run: IF (key exists) run update command ELSE run insert...

    ITKE350,945 pointsBadges:
  • Deciding on a RAID Level for a 64-bit SQL Server 2005

    I need to install SQL Server 2005 (64-bit) on two new servers, but these servers have only four hard disks with 500GB each. From what I understand, all my operating systems, data and log files will reside on these four disks. I have two choices: to use RAID Level 1 or Level 1 +0. Which RAID level...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server: Selecting the first row in a GROUP BY group

    I'm trying to select the first row of each set of rows grouped with a "GROUP BY" in a SQL Server database. Here's what my table looks like: > SELECT * FROM purchases: id | customer | total 1 | Joe | 5 2 | Sally | 3 3 | Joe | 2 4 | Sally | 1 So, now I'm trying to query the "ID of the largest...

    ITKE350,945 pointsBadges:
  • Extracting information with a DTS package from a database in SQL Server 2000

    We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we proceed?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Experience applying SP4 to SQL 2005?

    Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

    CarlMarius15 pointsBadges:
  • SQL Database is corrupted

    Respected sir, Unfortunately the hard disk of my system is damaged, now I recovered my database. but it cannot be attached again to SQL management studio 2005. The error is myfile.mdf is not a primary database file. (SQL server, error 5171) Please sir help me.

    shampur5 pointsBadges:
  • How do I save pictures in database VB.NET

    I'm using SQL Express to develop application which have I pictures so I can try how a save picture inside database and loading VB picture box. Can anyone tell me please? How do I do this?

    12345678900110 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