• run DBCC SQLPREF on linked server.

    I want to run DBCC command on linked server remotly

    Mangesh jadhav5 pointsBadges:
  • IT Career Path

    I am a new graduate with 1 year of experince in a well known Aircraft Manufacturing company. My title is "Database Administrator - Operations" and I deal mainly with SQL Server back ends with Visual Basic or HTML front ends. I currently deal with many internal customers and relay the feedback to...

    D-Nel5 pointsBadges:
  • Two Applications sharing the same database

    Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link . Question:...

    Said5 pointsBadges:
  • MS excel 2007 load data into database

    I am using MS excel 2007 and would like to upload data into DB2 database. I could do this before on my older version of excel. How do I do this with MS excel 2007?

    Geyes15 pointsBadges:
  • Giving Permission

    Hi, I am studing databases in a iSeries. All my objects are in librarie called DB1_T2. I need to give access to the professor so he can read all my data and execute my functions. How can I do that via the command line. Thanks a lot.

    Lv2eof5 pointsBadges:
  • MS Access – Email from form – VAR email receipients

    Hello, I have an access dbase and I need to email records (usually one at a time) to different receipients. The receipient name is part of the form and I have a table that lists the name and e-mail address. I am hoping to click a cmd button that will e-mail that individual the record on view. I...

    Asuasol10 pointsBadges:
  • Timestamps

    I wish to: 1.) define a timestamp and initialize it to system date/time. What odes the D spec look like for this or can it not be done in the D spec? 2.)Load a data structure whihc is formatted to match timestamp defaults with data by field (CCYY MM DD...etc,). I want to then 3.) Move this data to...

    Bigdog5510 pointsBadges:
  • How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?

    How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?

    Lokanath5 pointsBadges:
  • Oracle 10g on Windows 2003 virtual server

    We have installed a SQL server on Windows 2003 virtual server and there were performance issues. Will oracle 10g make a significant difference in terms of performance? Are there known issues concerning 10g DB running on Microsoft 2003 virtual server? thanks

    Markv5 pointsBadges:
  • Storing Binary Data

    I've been in the process of reviewing the pros and cons of storing binary data (e.g. image files) either in blob fields in a database (presumably MySQL) vs. the filesystem of a server. I'm aware there are some concerns of security, but I'm mainly interested in performance at present. I could easily...

    Chunter110 pointsBadges:
  • VB.NET ans ORACLE database

    Hi all. I know, that there is a big risk of asking a silly question, but I try to connect to a ORACLE 10g database witch MS Visual Basic 2005 Express Edition and all programming examples I found do not work. Is this a configuration that does not work? Or what software do I need exactly? What should...

    Flyer15 pointsBadges:
  • How to perform exploratory database testing using ERDs

    Can you please advise me on how to perform exploratory testing on a database using ERDs?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • Convert time as text to datetime

    I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You...

    VentureFree45 pointsBadges:
  • Microsoft Access

    I have created an Iff statement where it will compare two fields and return the bigger number. The problem is that instead of compare the numbers as a whole, it compares them digit for digit. Result is that it will return a value of 150 instead of the bigger value of 1040, because the second digit...

    Jaco65 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE351,905 pointsBadges:
  • Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

    Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connect to Sybase ASE 15 via MS SQL 2005

    I'm in a test phase and would like to connect to a Sybase ASE 15 server in much the same way as linking tables in access. How would I accomplish that?

    Bhassel25 pointsBadges:
  • Migrate an Oracle database to SQL2005

    I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!!

    mnman66265 pointsBadges:
  • MS Access ActiveX Control

    I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that? Thanks, Asuasol

    Asuasol10 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