Questions & Answers

  • SQL Query

    Employee: EmpID Name Company MGR_ID Date_of_Joining 1 Bhaskar A3 3 1-Jan-13 2 Ujin A1 3 1-Jan-13 3 Rex A6 NULL 1-Jan-13 Model: ID Model_Name Company Model_Type Harddisk OS RAM 1 750 Dell PC 600 GB WIN 7 4 GB 2 650 HP LAPTOP 400 GB WIN 7 6 GB 3 350 DELL LAPTOP 300 GB WIN 7 4 GB System: ASSET_ID...

    InformaticanSQL10 pointsBadges:
  • SQL&Informatica

    Design the dimension table for the following scenario ABC Company had planned to maintain complete customer information with following guidelines 1. Changes In the customer address to be maintained historically. 2. Only last two changes on customer telephone number – to be tracked. Example: If...

    InformaticanSQL10 pointsBadges:
  • Use SQL INSERT to Create Directories with FileTable

    This is my first experience with SQL Server 2012 and I'm not familiar with the limits of the FileTable from within SQL Server. Is there a way to create directories in a FileTable without using File I/O APIs? Is it just as simple as creating a SQL INSERT statement?

    ITKE342,860 pointsBadges:
  • Full text indexing in SQL Server Express

    Now, I've recently installed SQL Server 2012 Express Advanced Services, which is supposed to have Full-text indexing. I've already confirmed that it's running in SQL but when I try to create a full-text catalog, for some reason it fails. I continue to get this message: "Full-text is not supported...

    ITKE342,860 pointsBadges:
  • SQL Server 2012 Question: How to find last executed queries by database?

    Is there a way to find the last executed queries for a specific database in SQL Server 2012? I am able to find them using SSMS, but I don’t want to use SQL Profiler if I don’t have too. This is the query I’ve used to get the complete list of last executed queries. SELECT...

    ITKE342,860 pointsBadges:
  • Error message when restoring a SQL Server 2000 backup to 2012

    While I was restoring a backup from SQL Server 2000 to SQL Server 2012. This is the error I'm receiving currently:Msg 3169, Level 16, State 1, Server FF101, Line 1 The database was backed up on a server running version 8.00.0760. That version is incompatible with this server, which is running...

    ITKE342,860 pointsBadges:
  • SQL Server 2008: INSERT statement

    One of my family members needs some help! He has a table in SQL Server 2008 with the attributes name and ID. The ID is a generated value like this: INSERT INTO table (name) VALUES('bob');Now, he's looking to get back the ID in the same step. How can he do this?

    ITKE342,860 pointsBadges:
  • Can you create an Active Directory users group in SQL Server 2008?

    I am trying to connect a .net application to SQL Server 2008 using windows authentication. However, I can’t get it to work right because there are a lot of Active Directory users. I Know I could create separate login account for each of the Active Directory users in SQL Server instead of having...

    Chris Leonard4,300 pointsBadges:
  • GMT timestamp

    I am creating an XML document using RPG and I need to output a timestamp in GMT format : YYYYMMDDThhmmssZ The date will need to end up looking like this: 20131003T210212.001Z. Can anyone tell me how to do that in an RPG program on the iSeries?  Thank you.

    DStaats25 pointsBadges:
  • Gif

    How do you open a Gif file?

    Jim35 pointsBadges:
  • Unable to open EXLS file

    I'm unable to open an EXLS file through attached in Lotus Notes. After saving we are able to open the file.

    p4cm15 pointsBadges:
  • STMF

    What is STMF in AS/400?

    beniwal5 pointsBadges:
  • Adding Destop Shortcut and icon using GPO

    Hello, I’m hoping someone out here can assist me. Currently the users in my domain have a link in their IE favorites that is populated using Group Policy. Senior management would like this particular link to be placed on all users desktops as a shortcut along with a specific icon. I’ve copied...

    Crphgoldstein5 pointsBadges:
  • Linguistic Base for ‘Cap and Trade”

    Many definitions available but nothing on the origin of the phrase "cap and trade". What is the linguistic basis for the phrase? Thanks, Hugh

    Linguistics5 pointsBadges:
  • About database connection

    How to connect Visual Basic 6.0 project to the MS Access ACCDB file for save the data?

    mahajan5 pointsBadges:
  • Duplicate key on access path.

    I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....

    anuppdas105 pointsBadges:
  • Problemas despues de hacer un ENDSBS

    Amigos, tengo el siguiente problema, cuando bajo los subsistemas con un ENDSBS o un ENDSYS y despues levanto los subsistemas con un STRSBS QCTL no me levantan las pantallas verdes, la solucion que encontre fue dar IPL pero necesito que me ayuden a saber como puedo solucionar este tema sin tener que...

    nahuazky5 pointsBadges:
  • Workstation Entries vs Communication Entries

    I'm lagging with a clarity between Workstation Entries and Communication Entries. Can anybody explain me about which is meant for what ?to my understanding Workstation Entries are workstation devices for logging into the system for interactive work ?Communication Entries - ? this also do similar...

    qmaster1,675 pointsBadges:
  • Notification change in SQL Server 2008

    Now, I have an application in SQL Server 2008 that consists of a database and several services. One of the services adds information to the database (which is triggered by a user).Another service queries the databases for changes and uses the new data for processing.I used a configurable timer that...

    ITKE342,860 pointsBadges:
  • defination

    can i get a basic defination of shared mail box ( simple)?

    prabhdeep5 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