• Change SQL Server licensing

    Hi, I was wondering if it is possible for a 50 seat (i.e. maximum of 50 connection) SQL Server 2000 or 2005 license to be change to a 10 seat? If it is possible is there any limitation on the number of seat that can be change? Thanks

    Db23290 pointsBadges:
  • The most-watched IT questions this week: Oct. 6, 2009

    Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How to...

    Michael Morisy7,943 pointsBadges:
  • Best way to copy large amount files

    I have 50 GB of files on an iServer that was copied onto an external hardrive.  What is the best way to copy these files onto a Seagate NAS Server.  The external HD is plugged into the USB and appears as a drive.  Should I use xcopy is DOS or can I drag and drop in windows SP?

    Gyakstis5 pointsBadges:
  • 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 Morisy7,943 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....

    ITKE56,495 pointsBadges:
  • Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE56,495 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:
  • sql update command to update a date-of-birth

    I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR

    Mji50 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