Recent content by GShort

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?

Sorry to waste eveyones time. Apparently he just informed me that he was typing his password incorrectly.

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

shorty545 any updates on this?

What is a good third party tools to complete this task?

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

For hardware we are using a DL380 G5 with a single 2.33 Xeon Processor ,2.00 of RAM and a HP P400 Controller Card. On the network we are using the built-in NC3773i Gigabit NICs but I can not tell you for sure if we had them in a network team when we were having the problem. Don't think it...

Well it has been a while but it came down to I couldn't find any other problems. I used the TD Kit from Tandenberg and did not find and errors and then I did a backup to disk and no errors. At that point I decide to replace the card and it worked.

Thanks for the dull crayon explnation ;). I have it working the way that you discribed and I find it much nicer then the dynamic sql since I can change the query very easily.

Xlbo, I was unable to get the parameter to working with the table properties. In the parameter I have the following in the Available values: Label = Account Number I have tried serveral things on values Value = Fields!CUSTNMBR.Value or =Fields!CUSTNMBR.Value or "=Fields!CUSTNMBR.Value" or...

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

Well I found this and it great that I told the web programmer and he took credit for it too :p . http://www.sql-server-performance.com/stored_procedures.asp Anyway here is the link that I gave them and specifically the WITH RECOMPILE command in the stored procedures.

It is usally about a day and the data is is off of live data. There are two variables of start date and end date.