• Open IT Forum: What are your views on social networking platforms in your network?

    I chatted with David Sacks, CEO of Yammer, last week at Enterprise 2.0, and we talked about IT's changing attitude toward cloud-based offerings such as social networking platforms. I'd love to hear from practicing IT professionals about the impact of these platforms on the network, whether it's...

    MelanieYarbrough6,345 pointsBadges:
  • VNC over Broadband/internet

    Hi all, My IP skills are somewhat rusty - could someone please help me with some high-level steps to remote control using VNC over the internet... scenario: Customer down the road is always requiring assistance - usually I need to jump in the car & go there to sort out the latest dilemma. I'd like...

    SCOOBAMAN0 pointsBadges:
  • Validating Active Directory login from within a stored-procedure

    I have an application that needs to use active directory to ensure user login is valid. The issue is that the machine is in a different domain than our AD server. I am looking at creating a clr procedure on the SQL server that is in the same domain. Then from the application execute a procedure...

    Joetig35 pointsBadges:
  • Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command

    i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

    Mdshadabalam85 pointsBadges:
  • Trustworthy Self-study material for SQL Server and Oracle

    As a novice, I am seeking advice regarding the best (trustworthy) self-study material for Microsoft Sql server or Oracle exams and that would teach me what I need to know for training.

    RLT5 pointsBadges:
  • Open IT Forum: Are you on hacking offense or defense?

    Sony isn''t the only company getting hit hard by hackers. Sega just joined the bunch, and Lockheed Martin's breach is still fresh. How does your company set up a strong offense against hacks and breaches? Or, if your company's security has been compromised in the past, how did you respond and set...

    MelanieYarbrough6,345 pointsBadges:
  • Optimize SQL 2005 databases on a schedule

    How can I optimize my SQL 2005 databases on a schedule?

    NewnanIT1,110 pointsBadges:
  • Search: Error with SQL : Login failed for ‘SA’.

    I'm using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I've been having the following error anytime a call for a screen in the software"Search: Error with SQL : Login failed...

    PrinceBismark25 pointsBadges:
  • SQL Server Patch

    How do you get notified when Microsoft is doing a SQL Server Patch? Is there a way to be alerted before they do a patch?

    Amfaust15 pointsBadges:
  • Can you use variables as input and output when calling a stored procedure in COBOL?

    If you move data into your variable before calling your procedure, can the procedure then return a value back, which might be different? The procedure will intially be searching for the variable data, but, according to our .net programmer, will return a blank or null if it does not find the data....

    Bunkyg15 pointsBadges:
  • Free IT Book: Securing SQL Server

    This week's free IT book is written by one of IT Knowledge Exchange's very own members, Mrdenny. Securing SQL Server promises to help you "secure your SQL Server database so the outside world can't access your internal data." With Mrdenny's extended experience in simplifying SQL speak via his blog,...

    MelanieYarbrough6,345 pointsBadges:
  • SQL code made simpler

    I have 2 files that are clones - created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the...

    PSMurray530 pointsBadges:
  • System tables in SQL Server

    How to view System tables in drop down menu of a database in SQL SERVER 2005

    VendoorMohankrishna5 pointsBadges:
  • Convert Oracle code to Microsoft SQL code

    I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?

    VelameLaCosa110 pointsBadges:
  • DBF in AS/400 – last record written

    Hi , There is  file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it.   Thanks

    Atti123135 pointsBadges:
  • View in SQL 2000

    How to create view with parameter? Thanks and regards.

    Pkaur65 pointsBadges:
  • UNICODE Characters

    When you run the query below: SELECT '✘ РǻuľO Čєѕaя ™' She is returning this: "?? Ulo C? To? ™" How to query return without truncating the text?

    Caiquedourado5 pointsBadges:
  • EmployeeNumber query in SQL Server 2008

    I am trying to write a query that will generate employee numbers. Employee number = first initial & first 7 characters of last name. UNLESS that is taken, then it's first initial, first 6 characters of last name, then the number 1. UNLESS that is taken, then it's first initial, first 6 characters...

    Mmdmurphy30 pointsBadges:
  • Free IT Book: Achieving Extreme Performance with Oracle Exadata

    This week you could win a copy of Achieving Extreme Performance with Oracle Exadata from Oracle Press. Chock full of best practices for Oracle Exadata Database Machine deployment and maintenance, this resource covers data warehousing, transaction processing, consolidation strategies, maximum...

    MelanieYarbrough6,345 pointsBadges:
  • Application compatibility with SQL Server 2005

    We would like to upgrade from SQL Server 2000 to SQL Server 2005, but we are currently also using PowerBuilder version 6.0. How can we determine if our version of PowerBuilder is compatible with SQL Server 2005?

    SQL Server Ask the Experts2,585 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