Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by chewyone

  1. chewyone

    Spot the incorrect syntax..!

    I had it all wrong... I took it from Access to SQL so a few adjustments were needed. This worked perfect: UPDATE APTLocal.dbo.[User]SET PersonUID = '999999' FROM ((APTLive.dbo.Person INNER JOIN APTLive.dbo.Employee ON APTLive.dbo.Person.PersonUID = APTLive.dbo.Employee.PersonUID) INNER JOIN...
  2. chewyone

    Spot the incorrect syntax..!

    With the below code, I keep on getting the following error: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '('. Can anyone spot the problem please..?! Thanks! UPDATE ((APTLive.dbo.Person INNER JOIN APTLive.dbo.Employee ON APTLive.dbo.Person.PersonUID =...
  3. chewyone

    Can I put SBS 2008 on an already in place domain?

    Hi, We're taking a look at SBS 2008 as it has a lot of features we would like to use as well as Exchange. We have a domain in place that is controlled by a W2K machine, can SBS be put in place on our domain without being the controller and will it play nice? Thanks!
  4. chewyone

    XP won't open a USB drive previously used with Vista

    Thanks Linney, I'll try a couple of those tomorrow, 9pm so off home!
  5. chewyone

    XP won't open a USB drive previously used with Vista

    I plugged it straight in the the MB (SATA) and no difference. Any suggestions??
  6. chewyone

    XP won't open a USB drive previously used with Vista

    I don't get an error message. I plug the drive in, XP installed it okay, and the Autoplay window pops up momentarily, but nothing shows. In My Computer it has been given a drive name but you can't see the drive size and when I double-click on the drive, I get a pop up that says 'Disk is not...
  7. chewyone

    XP won't open a USB drive previously used with Vista

    Hi, am in a bit of trouble here... I wiped and installed XPSP2 Professional on a machine that was previously running Vista Home Premium as the machine was crawling. The guy who owns it copied all his files onto an external USB drive before I did the install. Now the USB drive installs okay on...
  8. chewyone

    Terminal Server License Expired

    Hi itsp1965, To answer your first part, no, we don't need the terminal services, all we need is the Administrative Remote Access. The server is also an application server, this application uses SQL and has been highly customized over the past few months and if there is even the slightest...
  9. chewyone

    Terminal Server License Expired

    Thanks cmartin75, that does indeed work if you put it in like this: mstsc.exe /v:server /console That's only going to work as a temporary solution though as there would quite often be two of us that need to be logged in at the same time. I didn't know that Terminal Services are supposed to be...
  10. chewyone

    Terminal Server License Expired

    We have a Windows Server 2003 machine which we installed a few months back. It’s being used as a SQL Application server. Terminal Server was installed on it and the warnings about licenses expiring have pretty much gone ignored up until today when I discovered that the license has indeed...
  11. chewyone

    ODBC Problem and SP4 issue

    Hi, If someone can help me with this I'd really appreciate it! I installed SQL Server 2000 Standard Edition on Windows Server 2003. This server is due to take over from our present Windows 2000 Server. It was my first time doing a SQL install, so I ended up calling the instance...
  12. chewyone

    Reinstall of a HP Pavilion dv2000

    Hello! Can anyone give me some advice on reformatting the drive of a HP Pavilion dv2000 with Vista Home on it, and installing XPSP2? I just started off an XP install there but setup couldn't find any hard drives. I did a quick google and found bits and pieces here and there about how much of a...
  13. chewyone

    PHPMyAdmin

    Thanks for that! I just downloaded and installed MySQL Administrator straight from the MySQL website and it's working perfectly. The PHPMyAdmin was recommended by the good folks on the OTRS website so I didn't think to look for an alternative as I'm brand new to this. Thanks again!
  14. chewyone

    PHPMyAdmin

    Apologies for my noobness and apologies if in wrong forum. On an XPSP2 machine, I set up this trouble ticket thing called OTRS a while ago. It comes as a bundled installer with Apache2.2, MySQL, CRON for Windows, Perl and otrs itself. After a bit of jiggery pokery, it's all up and running...
  15. chewyone

    Extraction errors occuring

    Sorry, don't know how that repeat happened
See more

Part and Inventory Search

Back
Top