• 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:
  • 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,875 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?...

    ToddN200015,605 pointsBadges:
  • I need the date to go to my dataTable

    I have a form that updates the amounts a parent is either charging or paying which is working but I need the date to go to my parent table also for the date of a payment or a separate column if it was a charge. I would put my code on here but I dont see a place for it. Private Sub...

    brendaStrub5 pointsBadges:
  • Exchange – extracting email properties

    Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account - I don't want the content of the emails - but what I want is emailID, subjsy, date received and it's current location (ie what folder is it in) in that email account. I need this...

    dragonsong15 pointsBadges:
  • Convert from text to number – exporting to Excel 2003 from SQL Reporting Services 2008 R2

    Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying "The number in this cell is formatted as text or preceded by an apostrophe". I have to sum my report values and this can only be done after I convert each...

    DhivyaJ10 pointsBadges:
  • Server upgrade 2003 to 2008

    I'm upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I'm getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.

    dthomas51865 pointsBadges:
  • Importing Excel data into SQL Server and filtering columns of Excel data in SQL

    I'm trying to import Excel sheet's data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?

    dammu5 pointsBadges:
  • Unidirectional replication in SQL Server 2008

    Can transactional replication be bidirectional?

    Dougm10 pointsBadges:
  • Linked server SQL select into

    I'm trying to create a stored procedure that will trigger every 15 minutes via a server agent job. I need to pull data back from a linked server to our SQL server. The tables have the same columns/fields just different names. I know the linked server logic works because I get the data if I run this...

    ToddN200015,605 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