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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. siituser

    Integrate Outlook OWA into current web application

    This is general question that I'm putting out there. We are moving to Microsoft Exchange (from Lotus - yikes!) for our mail server and I want to use Outlook Web Access as the primary interface for mail and calendar. I also want to integrate OWA into our current web app so that my users can...
  2. siituser

    How to create a FK in T-SQL

    I need to create a FK relationship in T-SQL. I've only ever done these in Enterprise Manager. The table already exists. I was trying to use: ALTER TABLE emailsendlist add CONSTRAINT FK_EmailSendList_ActivityType but I think I need a few more parameters. Thanks in advance! Kevin
  3. siituser

    Outlook 2003 not repsonding

    There is no HD light when it stops responding. I was attempting to get mail today and it hung half way through the load. If I double click on the Outlook icon in the sys tray, the bubble says "Outlook is not repsonding. If you are using an Exchange server email account, you can cancel...
  4. siituser

    Outlook 2003 not repsonding

    I'm having 'the' issue with Outlook not repsonding after a few seconds of opening it. I have seen some posts regrading this but never any fixes. Problem started in Outlook 2000. The current PST file is at 512,000 MB - kinda big from what I understand. I don;t think I been archiving...
  5. siituser

    cfexucute issue - restarting jrun

    I'm trying to use CFEXECUTE to restart JRUN on a different server. The following code will restart JRUN.exe on the same server it is called on. <cfexecute name='C:\WINDOWS\SYSTEM32\cmd.exe' arguments='/c "TASKKILL /F /IM jrun.exe"' /> If I run TASKKILL /S servername /F /IM jrun.exe in a...
  6. siituser

    Moving multipl;e data files to one file.

    Arg. I don;t really have a reason for the multiple files except to say that a third party company set up the database that way. The reason I want to go back to one file is that it makes it much easier to back up the data and restore it to our backup production environment and our dev server...
  7. siituser

    Moving multipl;e data files to one file.

    One of our datatbases (SQL Server 2000) has 4 data files that are limited to 2 Gigs each. There are also 2 transaction log files. I'm planning on moving the database to a different server and I'd like to combine the 4 data files into one that will grow automatically. I can not seem to find a...
  8. siituser

    muliple reoceds in a Case statement

    thanks - that was perfect!
  9. siituser

    muliple reoceds in a Case statement

    I've got a fairly simple Case statement: Select (Case when(Select distinct TSR.QP From TSR where TSR.DateStart between Date1 and Date2 and TSR.isActive =1) = 0 then 0 when(Select distinct TimeSheetRaw.QuickPay From TSR...
  10. siituser

    Converting varchar to int list in a Stored Proc

    FAQ183-3979 worked great - thanks!
  11. siituser

    Converting varchar to int list in a Stored Proc

    Hi there, I'm passing in a list of numbers a varchar (2,3,4,5,6) into a stored proc but he SQL needs to convert the list to an integer data type. CREATE PROCEDURE my_proc @strBranchIDs varchar(255) AS SELECT Users.UserID, Users.OfficeID, Users.UserInitials, Users.FullName FROM...
  12. siituser

    One CF application accessing 2 different SQL databses

    Hi there, Our CF application access our main database under heavy load very well in the past. Both SQL server and CF server (MX 6.1) are on the same box, dual 1GB processors, 3 GB RAM. We reccently let our application do same transactions to our Great Plains financial server, different box...
  13. siituser

    Proper locking syntax for database

    I have a question regarding proper naming syntax when doing a cflock. I have been creating locks this way example <cflock name="new_lock_name" type="readonly" timeout="15"> UPDATE/INSERT QUERIES </cflock> 1. Can the name be an actual word or is it better to use a unique lock for every lock...
  14. siituser

    SQL server SPID blocking all processes

    Hi there, We are running SQL server SP3 and a Coldfusion server on the same box. We manage our client variables in Coldfusion by using a SQL database. In the last 2 weeks, there have been very regular occurances of one SPID blocking all the others and hanging our applications. If I manually...
  15. siituser

    iMac stopped booting

    Most of the time it is fine and wakes up. Only occassionally does it freeze and I ahve to do a hard reboot.
  16. siituser

    Verity collection stopped working

    Found our problem. The result sets were over 64K in size and CF can not handle that. Does K2 fix that issue or is this a completely CF thing.
  17. siituser

    SQL server stops responding same time every day

    I'm having a problem with my SQL server(SP3). Last week, it started to not respond and this has continued at around the same time every day. Task Manager shows the SQL server activity at 0. There are no logs in Enterprise Manager to show any problems. No issues in the Application or System...
  18. siituser

    iMac stopped booting

    Here's the update - replaced the battery. If I shut down, the computer will still no boot. Have to press the button. Next step - find a motherboard. Thanks for everyone's input.
  19. siituser

    iMac stopped booting

    Got it to work - kinda. While is was upside down I pressed the button on the motherboard and it did boot again. Only thing is that you have to use that button. Sounds like the motherboard is starting to go. Moving all needed files as I type this. Thanks for all info guys. Cheers.
  20. siituser

    iMac stopped booting

    Thanks for the advice. I think I'll test the battery first as it that will be the cheapest way to go. I'm not getting ANY power to the keyboard or mouse there is no way I can zap the PRAM and I've waited 30 mins for the CD to show up with anything. Unfortunately, I have this feeling that...

Part and Inventory Search

Back
Top