• Need to create a bootable server 2003 CD

    Hello, I have a burned copy of Server 2003 Enterprise edition that a friend gave to me. I'd like to install it on my test server, but am unable to because the CD is not bootable. I have tried booting the server with a 98SE floppy boot disk but am unable to run setup through DOS. I currently have a...

    Kfettig5 pointsBadges:
  • Install SQL server client tools

    With client utilities like query browser, or query analyzer...how do I install on client workstations? I am not interested in installing a SQL server. I should just be able to query a SQL server and display some results from my laptop. Can anybody guide me? Well, if we have to buy any licenses we...

    Krblr200720 pointsBadges:
  • Receiving undeliverable email we did not send

    Hi everyone, One of our users keeps getting undeliverable email messages. It looks like someone out there is sending mail and making it look like it is coming from him. Is there anyway to stop this? We are running Exchange 2007. I don't think it is relaying or a virus. It does this even when his PC...

    Fuddstud0 pointsBadges:
  • Creating second instance on SQL Server 2008 cluster

    Hi, I need help to create second instance on SQL 2008 Cluster. I have active/passive Windows 2008 R2 cluster and currently using a default instance of SQL. Most of the blogs mention that installation of new instance is same as the first one and you need to provide IP, network-name and disk...

    PowerEdge5 pointsBadges:
  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 pointsBadges:
  • ORA-06502: Character string buffer too small

    Hi guys, Here's my script I have created aggregate string function 'Tab_To_String' using this below script CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION Tab_To_String (p_varchar2_tab IN t_varchar2_tab, p_delimiter IN VARCHAR2 DEFAULT ',') RETURN...

    Kruti123456789shah15 pointsBadges:
  • Multiple DHCP Scopes for multiple VLANS

    I am using Windows Server 2003 as a DHCP server. I would like to have centralized DHCP management using the one server to give out addresses to each of the 3 VLANS. We are also using Cisco switches and I planned on using the dchp-helper to allow the DHCP packets to be forwareded to the server. I...

    Skepticals0 pointsBadges:
  • Referencing a calculated column in a SQL clause

    This is our SQL code: Select addrid,addrkey,addrline1,addrline2,addrline3,addrcity,addrplace,addrzipcod,addrtype,addrphone,jobsconame,addrmc1, CASE month(getdate()) WHEN 1 THEN addrjan WHEN 2 THEN addrfeb WHEN 3 THEN addrmar WHEN 4 THEN addrapr WHEN 5 THEN addrmay WHEN 6 THEN addrjun WHEN 7 THEN...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Passing parameters to report viewer

    Hi Kindly excuse me if I appear a bit ignorant on this subject as I am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which I have successfully deployed to Report Server. The report basically uses a stored procedure which has...

    Shaygen5 pointsBadges:
  • Concentrate more than two fields together into one field in SQL

    Say I have 3 columns: 1st name, middle name and last name. How do I merge the 3 columns into one column yet separate the content with commas?

    Sammy545 pointsBadges:
  • USB External Hard drive and Windows XP

    I have two issues which are basically the same. I have an external USB hard drive that I connect to a computer running Windows XP. Windows USB driver recognizes the hard drive and shows the drive in Device Manager but Windows does not show the drive in Windows Explorer. A customer has a USB FLASH...

    Cestanley0 pointsBadges:
  • Any unsurpassed method to start-off this procedure an appropriate

    I’m used to a setup which welcomes anyone who wishes a sort of an executive entry to a domain only to get imputed to the domain admin’s group. I apologize for such faulty actions, and am now separating all of our “admins” into their own groups. Specifically, I have users who require...

    KaziMamunur35 pointsBadges:
  • SQL Server Restore history (last restore date)

    I am trying to find when the last time a database has been restored. We have several SQL servers. I have formed the following query based on an article I found. It worked great on the first one I tried, but wasn't recent enough. When I tried to go to other servers looking for a more recent version,...

    Scott000 pointsBadges:
  • How to select 1 record in DB2

    As usual, I often use: select top 1 * from table but in DB2, I can't. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!

    Linhntk5 pointsBadges:
  • Access

    How do I access SQL data in software?

    shafi5 pointsBadges:
  • IF ELSE in SQL Server stored procedure

    I am using this code which is giving error: if (@report_type = 'CM') Begin Select distinct Region,sum(ClientCount) as ClientTotal Into #NewTemp From ( End else if (@report_type = 'AM' ) Begin ( Select distinct Region,Area,sum(ClientCount) as ClientTotal Into #NewTemp1 From End else if (@report_type...

    Rrj15 pointsBadges:
  • How to read MS SQL tables using iSeries RPG

    Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?

    WoodEngineer6,680 pointsBadges:
  • SQL Plus stops before finishing

    Why does SQL+ stop after running so many characters in a long SQL statement?

    rayfish201315 pointsBadges:
  • Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?

    Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a Cachè Database. I was...

    FernandaAraujo45 pointsBadges:
  • webservice and iDB2 connections slow on startup

    We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the initial connection?...

    ToddN200011,190 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