Search results for query: *

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...

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

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...

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...

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...

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...

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...

thanks - that was perfect!

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...

FAQ183-3979 worked great - thanks!

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...

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...

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...

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...

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

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.

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...

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.

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.

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...