• Terminate SQL exception, if it is running more than a specified time.

    Whether we can forcefully terminate an sql statement during its execution if it is running for a long time or running more than a specified time?

    Liveena5 pointsBadges:
  • Can I backup the entire SQL drive?

    I have an application that uses SQL Express 2005. I will be upgrading the application and am planning for rollback should it be required. I have nightly database backups which also go to tape but I am wanting the entire hard drives of the server backed up to tape prior to the upgrade. As a rule, we...

    Carlyvehof5 pointsBadges:
  • .mdf file backup in Visual Studio

    I developed one Visual Studio .Net(C#) Project.After Publishing I couldn't access Database(.mdf file). can yuo tell how to backup?

    Zamak5 pointsBadges:
  • SQL SERVER SAN Setup

    I do not know much about SAN's, I want to setup a SQL Server to use a SAN. 1. Should I use a SAN drive to install the OS or is it best practice to install the OS on a local drive on the server? 2. Should I install SQL SERVER on the SAN or on a local drive on the server?

    Rick Martinez585 pointsBadges:
  • Filename from SQL 2005 Query

    I have a batch file that runs a SQL query command overnight once a week and outputs the results of that query to a file as a .csv file. The query produces, amongst other things, a week ending date. Is it possible to to name the output file with result of the week ending column in the query. All...

    Apbarker5 pointsBadges:
  • SQL Agent in SQL environment?

    what is SQL Agent in SQL Environment?

    Prcvjr220 pointsBadges:
  • How to find particular database in SQL stored procedures other than manually?

    Hi all, i have a Stored Procedure, i need to find the database in which the particular SP is available, i dont want to go through all the SP's........... Is there any way to find the database using server name, i need the query for this.. Please help me

    Sagi5 pointsBadges:
  • I know SQL, should I learn Oracle database?

    I know SQL but i am not master in that.I know only basics of SQL. Can I start to study Oracle database directly? if so please suggest me some good way to learn.

    Prcvjr220 pointsBadges:
  • Question about SQL Server managament database upload

    how to upload sqlserver management studio database on online

  • Remove double qoutes from text file using SED in SQL 2003

    This goes along with my previous question "How to remove specific lines from a text files using either vbs or bat." I am having issues removing the double quotes our app uses in its export as a separator for some fields. The command I use in ssed is ========CODE=================== "s/"//g"...

    swinehart68031,050 pointsBadges:
  • AS400 RUNSQLSTM – Problem with CAST

    I am using a RUNSQLSTM to insert records from file A into file B. One of the fiels in defined as 4S 0 in file A and as 4A in file B. If the value in file A is zero, not matter what I have tried file B gets populated with a 0 followed by 3 blanks. I need to be '0000'

    CharlieBrowne41,370 pointsBadges:
  • Linking Access to SQL Server

    Hi ive got alot of linking tables in Ms Access and I want to link in onto Sql Server 2005.how to i do the liking part

    Ilse5 pointsBadges:
  • Backup Exec

    Hi I have Backup Exec 20210 installed on a windows standard 2008 server 64 bit. At first it ran ok and allowed me to setup a backup schedule, now when I try to run it comes up with the following error ,HERSULT: 0X8007000B)  I have SQL 2008 installed on the server but we have a separate Instance...

    Markl5 pointsBadges:
  • How can I see SQL VIEW inside ?

    Dear Friend, I see the VIEWS on AS/400 as logical file,but I don't know wit which SQL it is created. How can I see the SQL Sentence of this VIEW ?

    Vkarakuzu20 pointsBadges:
  • cpyf and cpysplf: How to copy spool files and database files in AS/400?

    Hi, Can you give me the what are the steps to copy the data from one pf to another pf using cpyf? and how to copy the data from spool file to database file using cpysplf?  

    Girilabs130 pointsBadges:
  • Copy Table in SQLPLUS

    How to copy a table from an access database using sqlplus

    VB and Access5 pointsBadges:
  • Orace v/s SQL Server careers

    Hi, I am newly join a job on Sql Server.Is it having good future?  I heard that Orale is more good and having good career. Please give me ur valuable suggestions.

    Prcvjr220 pointsBadges:
  • Database files in Oracle 9i

    i had installed in my PC oracle 9i. i dont have time in practice in niit instutute. i had decided i will prctice in my home but problem is i dont used database file in oracle can u tell me setting about db files

    Varsha500950 pointsBadges:
  • Do you have an IT blog or website and want to earn 100 knowledge points?

    We hope you find this community helpful in answering all your questions. But we want everyone to get every answer they need and wthat means more experts are always welcome. That's why we're asking you to tell your friends about IT Knowledge Exchange (ITKE). If you have a blog or website that is...

    ITKE334,795 pointsBadges:
  • Importing a “flat” field into a Lookup Table format in SQL database

        * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated...).     * I have created a table...

    Roguetexan5 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