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

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

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

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

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

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

Hi there, I've read other posts with similar issues but I want to sure before I go riping his computer apart. I'm more knowledgable about the inner workings of a PC then an iMac. I have an iMac 350 slot loading, 512 MB ram, orignal 40GB HD. I upgraded to OS X version 2 a year ago and had no...

I have 6 different verity collections. One of the collections is a combination of the other 5 and would be quite large. This collection seems to update fine, but it will not bring back any results to queried against. The other 5 collections work great. We are using the basic Verity engine...

Hi there, My home network works like this: Cable modem to a hub - this breaks my connection to a) a NetGear router (my VPN into my external office) and b) to a Linksys router. These 2 routers go into a switch that feeds the rest of my house. Far, far away (upstairs) I have yet another...

Hi there, I'm searching for an elegant solution for a problem. I've got 2 lists and I want a user to be able to create a 1 to 1 relationship or a 1 to many relationship between these lists. I never seen anything like before ( or paid attention to it if I had). I've thought about using 2...

Hi there, I'm working on an intranet site (so I'm less concerned with the whole use of pop-up thing). One form entry system spawns a pop-up window to work in. I need to spawn another pop-up for a calendar selection. When I try to open a new window, the page just loads in the exisiting...

Hi there, I've seen some examples that are close but not exaclty what I'm tring to do. I've got 2 select drop downs for choosing a date range. (FROM: and TO:) Each select has a list on days in the month 1 to x (depending on how many days). When the user selects the FROM date, I want the...

Hi there, In an attempt to optimize our app, I'm trying to reuse a number of queries. I've got a bunch that are similar except for the Order By statement. I'm thinking that if I just lose the Order By line of the query I can reuse it all over the place. I just need to sort it the way I want...

Is it possible to make a webservices connection over https? I have created an app that uses webservices over http but I can't seem to create a connection in Flash using https...

I'm having to modify a Stored Procedure. I'm trying to calculate the number of days worked down to the decimal. So far, I've got : Select ((DateDiff(d,'04/01/2004','04/29/2004') / 30) * 21) (only more elegant)... now according to my math, ((28/30)*21) = (0.93333 * 21) = 19.59 but I keep...