Questions & Answers

  • Sorting hierachy data alphabetically in SQL Server 2005

    I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Accessing the Northwind database in SQL Server 2005

    In SQL Server 2005, I am not able to access the Northwind database. Some people have said that it is built into the SQL Server, but I can't access it. How would I do so?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backup Programmability in SQL Server 2005

    How can I backup the Programmability (functions, triggers stored procedures etc.) as part of a schedule job? Do I need to write code or can I use the wizard?

    IT Systems Analyst15 pointsBadges:
  • Connectiveity JAVA to Sql server 2000

    Dear all, I have problam to connect SQL 2000 server with jdbc driver.\ i m using windows 2003 server SQL server 200000 and jbuilder. anyone have jdbc driver for the same environment thnaks

    M.Asif5 pointsBadges:
  • Error installing the client tools for SQL Server 2000 onto an XP desktop

    When attempting to install the client tools for SQL Server 2000 onto an XP desktop, I get an error stating that “A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.” Rebooting only leads to the same...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating from MS Access to SQL Server Express

    I've just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • BlackBerry getting non Lotus Notes inbox emails now.

    I have email rules setup in Lotus Notes that keeps me from getting 100's of our system emails by sending them to other folders and has been working that way for years. Last week even though Notes is still sending the emails to the correct folders, those emails have started going to my BlackBerry...

    mjonesjr815 pointsBadges:
  • Problem sending notice accepting calendar invite

    Whenever a user accepts a calendar invite from outside the organization, the following happens: - the meeting posts to the calendar correctly - the acceptance message is sent as coming from username@servername.mydomain.com Regular mail is sent as coming from username@mydomain.com Why is the...

    Stiletto3,790 pointsBadges:
  • Unable to take export

    When agent schedule then export not coming to directory.

    PravinPatekar5 pointsBadges:
  • SQL Syntax issue via Free-Form RPGLE

    I'm having difficulty with a select statement.  As below, it works .  If I remove the '//' comment-out tags, it doesn't, so obviously there's an issue with those statements.  I'm trying to populate an output 3-char field with either Yes, No, or N/A.  The Y/N comes from the contents of a field...

    Eric Witham690 pointsBadges:
  • Delete duplicate members from a physical file using RPGLE

    Hi, could someone please help me with the code to delete duplicate records from a physical file. Please post with the full code.

    AS400dot5 pointsBadges:
  • How to fix crw32.exe APPCRASH

    Just installed Crystal Reports XI on a Windows 7 machine and everytime I close the application I get the error below. How do I fix it? Problem signature: Problem Event Name: APPCRASH Application Name: crw32.exe Application Version: 11.0.0.1282 Application Timestamp: 422d5c77 Fault Module Name:...

    dserran5 pointsBadges:
  • What’s tender management?

    Today, I saw the software about Tender Management. But I don't know what it is used for. It needs to use what technologies? What is the demand? I was studying .Net, whether I can do it? Who can provide me the demand?

    st20135 pointsBadges:
  • Excessive transaction logs being generated

    Hi, my Domino 9 server was running fine until recently where its now creating transaction logs at a rate of 15GB/hour (4 to 5 TXN log files per minute) which is way higher than usual. This server hosts applications only and is not an email server This happens during business hours as after hours...

    PaulWignall5 pointsBadges:
  • SQL Server 2008 R2: User table with clustered indexes

    I recently found that a couple of my tables in SQL Server 2008 R2 with no clustered indexes defined. However, there are non-clustered indexes defined (so basically they're on HEAP). After I did some searching, I learned that some select statements were using a filter on the columns defined (in...

    ITKE344,655 pointsBadges:
  • Cloud-based Testing

    Do you think opting for cloud-based services is better than having own testing lab for running performance tests? Can I have one example?

    Cloud12310 pointsBadges:
  • change Mocha 5250 keyboard setting

    In Mocha 5250 'Esc' key doesn't work in window 98.... i re installed mocha software, after also i got same problem...

    pdsathishkumar3,790 pointsBadges:
  • .dts and .dtsx config files in SQL Server 2005

    Hi I have .dts and .dtsx config files. i want to execute these packages in the db server, can u tel me what are the steps required to attach and configure these packages for it to execute?

    Sangeeth30 pointsBadges:
  • how can make this SQL Server query faster

    All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as '00', ISNULL (td1.price, 0) as '100', ISNULL (td2.price, 0) as '200',...

    Singhal120 pointsBadges:
  • Front-End Reporting Tools for Secure Web Service Application with MS-SQL server-2

    Hi... We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small secure web service application for reporting purposes that will require minimal IT expertise to build or maintain, and will deliver maximum...

    Mmosystem0 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