Search results for query: *

I have report that is required to list the all of the inventory cost in it separate locations, and they want to sum all the product costs except for one of the items item. I was thinking a matrix was the best way to go about this but I am not aware of a way to only add certain rows. Does...

I have recovered a database and I am trying to restore certain mailboxes from the database. When I try the dispaly name that it should be it say that the mailbox does not exsist. The restore is from a windows 2008 server backup. Is there a way to list all the mail boxes that exsist in the...

We have recently upgraded to Exchange 2010 but we have been unsuccessful in configuring an Entourage 2004 to work with the DAV service. Has anyone had any experience getting this working? Is there any special setting needed to the default settings on the exchange server?

I have a new SQL person that just started. I am having an issue where he is unable to see the security screen. I have made him a local admin to the box that SSRS resides on but it still does not give him the ability to view and modify this page. Thanks

We are currently in a legeal process that requires us to collect data from our Exchange server. I have 8 key words that our lawyers want us to search on, and if any of the words exsist anywhere in the e-mail they would like a copy to review it. I know that I can search each mailbox one by one...

I have a report that shows customers service calls for remote offices. They consist of Customer Number, Start Date & Time, Address, Zip. Several of the offices have a large amount of tickets and would like to sort the report by zip code for planning reasons. By default the report is sorted by...

Hello all, We currently have a stored procedure that is giving us fits. We use this stored procedure on a web site to give our sale staff there stats. This stored procedure seems to run fine at first but slows done after time. We found that if we run the stored procedures code (we physicaly...

We have a Stored Procedure that when ran in the SQL Server Management Studi takes about two seconds to run. But when I place the Stored Procedure in a report to run it takes roughly two to five minutes. I am a quite perplexed by this problem, any suggestions?

Hello all, I am running Windows 2003 with an Adaptec 29320A-R (Raid is off and ) hooked to a Tandberg LTO-3 StorageLoader (HP LTO Ultium-3 drive) and we are running Symantec 11D. I just set this up so it has never worked. It seems that everytime the device begins to read data from a tape I...

I have installed a new digital 30. But after it is plugged in I get an amber light in the middle instead of the usual green light that shows up on my other two digital 30s. And if I plug phones in they just say Please wait.... I am running 3.2 on my IP 406 and the new digital 30 is version...

I am very novice when it comes to transaction logs so any help would be great. Right now I have a Customer DB that is roughly 260 MB and the transaction log is 31GB. The DB is being backup nightly with a full backup just using SQL Server Management Studio. I can't imagine that this is normal...

I have a single analog line that I need to send the CLI to a partner to test on of our systems. Right now we are returning our companies main number which is not the correct line that need to be sent. Sending: (***)***-6500 Need to send: (***) ***-6679 We are delivering our number by usning...

Not sure what has changed over the weekend but I am running into a problem where when I do a NSLookup I get the name of the server Servername.domainname.com but I don't receive the IP address. I have an alias pointed to the IP address of the website directly and I have deleted it and recreated...

We are trying to use multiple site with multiple IP address on one server. We have assigned IP address 10.0.2.30, 10.0.2.31, 10.0.2.32 to the network card, but IP 10.0.2.32 is not showing up in IIS to assign to one of the web sites. We are using an HP DL360 G5 with dual nics and running IIS...

Hello all, I am looking for a way to send a company wide mass mail. Now this would be easy if all the people that we were trying to e-mail were exchange user but sadly they aren't. Below is what I am looking for (as requested by one of the owners.) He has a spread sheet that he copies and...

I have a field that I am running a If statement against. Their are three way that the field state my be entered in and they are Data, Null, <Blank>. Of course I don't have any problem if their is data in the field or if it is null (I use a ifnull) but if the field is blank it return an error...

I have a field that I am running a If statement against. Their are three way that the field state my be entered in and they are Data, Null, <Blank>. Of course I don't have any problem if their is data in the field or if it is null (I use a ifnull) but if the field is blank it return an error...

I am trying to put a workorder report together for our service department but I am running into a little problem. When I put a text field into the a report textbox it does not recognize the returns. The field in the DB has a square where a return should be. I would post what it has but this...

I have the following select code: SELECT dbo.SOP30200.CUSTNMBR, sum(CASE WHEN dbo.SOP30200.SOPNUMBE LIKE 'A-%' or dbo.SOP30200.SOPNUMBE LIKE 'I-%' THEN cast(dbo.IV00101.USCATVLS_1 as numeric(2)) END) - sum(CASE WHEN dbo.SOP30200.SOPNUMBE LIKE 'RET-%' THEN cast(dbo.IV00101.USCATVLS_1 as...

We are using GP 9.0. Currently when we invoice our customers in Contract Administration and it creates the Sales transaction but without a Site ID and we have to manually enter each Site ID for each customer. We are billing a monthly monitoring fee in serveral states. We need to have the Site...