• Oracle LIKE statement on SQL Server 2005

    I'm trying to execute the LIKE statement but it's not displaying  any values SELECT R_NAME FROM LAWSON.DEPTCODE WHERE (R_NAME LIKE :r_name)

    Huhemp5 pointsBadges:
  • Reordering the Table position in SSRS

    Is there any provision to reorder the table position in a rdl? I have two tables, say A and B where A is placed after B at design time. Can I reposition them with B coming first and then A at run time?

    UmaD5 pointsBadges:
  • installing sql server 2000 32-bit on vista 64-bit

    how to install sql server 2000 32-bit into vista 64-bit?

    Alalifa20 pointsBadges:
  • Working TRIGGER and TRANSACTIONS QUESTION

    Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table,...

    LUISCGG5 pointsBadges:
  • The IT Blog Top 10: Oct. 1, 2009

    10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing....

    Michael Morisy8,323 pointsBadges:
  • Making a WAN

    Hi, I would like to know the best way to setup a WAN. We have 4 small companies and one main Head quarter.  2 companies are in one city and 2 are in another city. Below is the detail on what each site has. HQ(head quarter)- HP Mail Server (HP ML350) - Win 2003 Server + Exchange Server...

    PRINCESS85 pointsBadges:
  • SQL Server 2000 hang and shrink won’t stop

    I'm troubleshooting a SQL 2000 database problem. It's a db for our datawarehouse system that pull everyday data from host. Current size is 461Gb for db and 67Gb for log. Because of space concern, I want to detach the log file and create new, but today I cannot open the database locally or remotely....

    ITKE350,945 pointsBadges:
  • Getting last entries from two different tables

    Hi, I need to get the last entries from two different tables in MSSQL. I can get the last entry for one table by usung the following. SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) The problem is adding another table. Please help

    GPNel200675 pointsBadges:
  • SQL error

    I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

    Nutangujar895 pointsBadges:
  • sql 2008 system tray icon

    how can i add a system tray icon for sql 2008 just like sql 2000?

    Saga10 pointsBadges:
  • Optimizing Query that uses linked tables and bound form w/joins

    I have a bound form whose record source is an Access query.  That Access query involves 3 linked SQL Server tables (one inner join, one left join).  The form takes a while to open. I have run a SQL Profiler and it appears that access is sending two select fields from table without where clauses,...

    Jagoodie60 pointsBadges:
  • Error when insertin.g data into SQL table

                    I'm using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I'm having a problem of inserting data into one of the tables in my database through my VB.NET application. I...

    Obhasha0795 pointsBadges:
  • sql server

    what are the diferent versions of sql server

    Jideesh5 pointsBadges:
  • SQL Server 32 bit, AWE/3GB/PAE

    I have read quite a few articles that recommend turning on /3GB on a server with 32bit SQL server and 32bit Windows 2003 standard where you have between 4GB and 16GB or RAM. Why is /3GB needed? Just so SQL Server can have more VAS, and because VAS is better than AWE mapped memory? This switch...

    Jagoodie60 pointsBadges:
  • Upgrade to IDES CRM 7.0 (ABAP)

    Hi All, My client using sap IDES CRM 5.0 (ABAP) and he wanted me to upgrade to IDES CRM 7.0 (ABAP) . I am new to BASIS, can any one help , which CD's( with the CD numbers and related notes numbers ) to be downloaded from service market place and how to start the upgrade on a stand-alone system in...

    Raja5495 pointsBadges:
  • Windows Server and SQL database upgrade

     We are goging to upgrade server, SQL server databases and domain name, now currently using as following setting 1. Server OS - Windows server 2003 Enterprise Edtion. 2. SQL server 2000 3. domaname xxx1 we are looking and upgrade to new os version, server SQL server and change domain name. 1. ...

    ITKE350,945 pointsBadges:
  • Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB

    I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this?

    Minidach15 pointsBadges:
  • Contest Update: Nominate a member and you could win 1 of 5 Amazon gift cards

    A quick and important update on our Panasonic flatscreen contest and the nominations process -- we will be giving away five (5) $20 Amazon.com gift cards at random to members who nominate someone in the community feedback form here. Thanks!

    ITKE350,945 pointsBadges:
  • The most-watched IT questions this week: Sept. 22, 2009

    Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

    Michael Morisy8,323 pointsBadges:
  • Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc

    Here's the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport =  'Nov 14 2008 12:00AM' SELECT     LTRIM(RTRIM(T_ASFSTAG0.STANS1)),     LTRIM(RTRIM(T_ASFSTAG0.STHFO1)),...

    LeftForDead20 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