Re: Mail Box Store will not start after reboot???
The Container/Mailbox store will not start after reboot of
server? I would give the exact error message but I am not
able to reboot the box during mid day....
check what free disk space you have left?
"Jason" <firstname.lastname@example.org> wrote in message
> The Container/Mailbox store will not start after reboot of
> server? I would give the exact error message but I am not
> able to reboot the box during mid day....
I have 16gb being used on the c: drive w/ 3gb left free
The d: driv...Windows Server Enterprise and/or x64 editions at RMS
Will it work?
I'm running SBS 2K3 with 4GB RAM (OS Max) on a 3.6Ghz P4 Xeon and this thing
is just hammered. The server hosts one Store Ops DB and the HQ DB, plus HQ
server. It runs an automated backup and hosts Wildfire (a private IM
That's it. I don't run MS Exchange, I do have one printer queue that's
hosted by the server, but it might print 50 pages on a busy day--many days
it's none or just a few.
I do host about 10 users' My Documents folders on the server, but even that
traffic should be pretty easy for the server to handle.
If I buy a new ...Last Column
I have used a similar piece of code to find the last row of data by going to
the last row in the sheet and then moving up to the last row containing
data. I want to do the same albeit go to the far most column then go left
to fing the last column with data.
Cells(1,Columns.Count).Select takes me to the last column but adjusting to
the below, just errors.
dim ColNum as Single
ColNum = Cells(1,Columns.Count).End(xlLeft).Select
Any pointers most welcome. Rob
ColNum = Cells(1,Columns.Count).End(xlLeft).Column
"Rob" <anonymous@discus...Last Question regarding ITems
I am unclear as to how I should take care of this item... Take for example I
order a carton or case of items by I only sell these items by the single item.
So in a case there is 36 or 48 or 60 of one item. How Should I enter this
into RMS? I want to be able to buy 1 cs and recieve the inventory and have
RMS automatically make it so that I have 36, 48 or 60 of them available.
parent = case
child = individual like items within case
search help file for "parent child"
"Pr0ject" <Pr0ject@discussions.microsoft.com> wrote in message
news:F9E706E8-75B1-4E64-ACCF-72EAE...Sort on last two digits of data
A sorting question.
I have a sheet of data A12:BC77. I would like to sort this on items in
column A. The problem is I need to order it by the last two digits of the
data in Column A. So say ZWE11 will come before AA77 and QW22 will come
before BB55 and so on. There is probably a simple answer but it is missing
me at the moment.
All I can think of is splitting out the last two digits into a new column
and sorting on that, then deleting that column once sorted but seems very
Any advice will be very gratefully received
with kind regards
Hi Spi...SQL Server 2005 Memory
In case dynamic memory model, where there is min and max memory
Under what conditions would sql server 2005 decide to grab more memory or
give up memory?
Thanks in advance
It will keep grabbing memory as you are doing operations which which memory
is needed (like reading data which isn't in cache, or producing new
execution plans). It will stop, however when it reached max/or a bit lower
than memory in the machine (which is lower) or if Windows signals that the
memory in the machine is already used (other processes). I.e., SQL Server
tries to avoid ...Why is the last used cell being used?
From what I can see, my last used cell is D48. From what Edit>Go
To>Special>Last Cell is telling me, it's AF51.
But when I go to AF51, it is blank, has no conditional formatting, has
no data validation, and has no formulas. So why, is it the "last cell
used"? I can find alot of "Find Last Used Cell" macros, but nothing
that looks at your sheet and lets me know "This is the last used cell
because it contains__________."
I appreciate any help with this.
Excel has a better memory than you--and it doesn't contract that used ra...How do you change OWA to another server?
OWA is working on the exchange server through the website on the Exchange
server. First, is it a good thing to have the Web Server for OWA on a
different server from the Exchange server? And if so, how do you change
On Wed, 20 Jul 2005 15:20:38 -0500, "charles kuchar"
>OWA is working on the exchange server through the website on the Exchange
>server. First, is it a good thing to have the Web Server for OWA on a
>different server from the Exchange server? And if so, how do you change
>it...? charlie ...LAST, FIRST to First Last
I have data in LAST, FIRST and used this formula...
Is there a way to change it from all caps to just capitalized names.
currently - DOE, JOHN
change to - John Doe
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
"Erinayn...macro to find out the last cell in a range
i have a column which has a total in the end but the number of rows i
that column varies. I want a macro that gives me the total in a cell
specify in the same worksheet
Message posted from http://www.ExcelForum.com
You don't need vba for this. Just use INDIRECT where 16 is in cell g1 to sum
"vikram >" <<email@example.com> wrote in message
> i have a column which has a total in the...Email Classified as Spam After Scheduled Task Reboot
First of all, let me apologize in advance for the length of this post, but I
wanted to give as much detail as I could...
I have an intermittent issue with my Exchange 2007 server. Every Saturday
at 1am I have a scheduled task that runs a batch file to automatically
reboot my Exchange box. The reason we do so is to refresh the server and
services, which overall seems to make the system run smoother. At any rate,
occasionally, more so rarely, the server will come back up and our spam
software (GFI MailEssentials 14.0) begins falsely classifying many (not all)
...Server rule help!
I have a user who has a default SMTP address of firstname.lastname@example.org.
Tim also has an SMTP address of email@example.com.
I need to create a rule on the server that will deliver all emails that are
addressed to firstname.lastname@example.org to a specific folder. Preferrably a folder in
Tim's mailbox but it could be delivered to a public folder.
Any ideas on how to accomplish this? I really need this to be a server
On Tue, 18 Jan 2005 11:05:41 -0500, "Marc Thompson" <(NO SPAM) my
email address is marc at sycron dot com> wrote:
&g...COUNTIF to count last 4 letters in string
I'm trying to figure out how to count the occurences of the text
"cnty" in a column of text. "cnty" will always be the last 4
characters to the right. Can anyone help me here?
Thanks in advance.
You can use the formula (adjust the range to suit your circumstances...
"davegb" <email@example.com> wrote in message
> I'm trying to figure out how to count the occurences of the text
> "cnty" in a column ...Desperately need a way to run Internet Explorer 7 in 2008 R2
We just installed thin clients at a car dealership using Server 2008 R2. We
did not find out until afterward that one major site (www.bzbuzztrak.com)
will only run on Internet Explorer 7.
After 3 hours of trying workaround for the site, I gave up. Unfortunately
this is somewhat of a deal breaker and we need to get this working. Is there
any way - even radical way- that we can run Internet Explorer 7 with those
BTW, I did try all the software that will allow you to run multiple
instances of IE, but none work.
You can run IE8. I am running it on a W2K3 Enter...Memory leak causes Great Plains server to crash
I had a newer client who for weeks slowly had the situation with the GP
clients being unable to connect the GP server via ODBC. Finally the server
would crash and reboot.
I have an article in the Nov 2005 issue of WindowsITPRO Magazine about it.
The fix was a errant piece of software that generated over 700,000 file
handles in fifteen min. after the server reboot.
The physical memory showed that there was plenty of RAM but the filehandles
crashed the server repeatedly. Be on the look out for this behavior with
certain Mo...auto insert of last day of last month
I'd like to create a button such that on clicking it,
cell A1 will show the last day of last month, for
example, today is 20/5/04 so on clicking the button,
it'll show 30/4/04 in cell A1.
I tried using the following macro which I had used
previously for other purposes but it doesn't seem to work
in this case:
.Value = DateSerial(Year(.Value), Month(.Value) +
What code shld I use?
You could use the cell formula:
Or use the subroutine:
Sub LastDay...Forgot to uninstall Exchange before killing Server. Help Please?
I made a very stupid mistake the other day, I still can't believe it
but it's done and I gotta fix it now. One server in a small network
needed to be re-integrated because it was infected and corrupted. I
bring a small Dell server, install W2K Server, DCPromo it, install
Exchange 2000 and migrate all mailboxes and AD accounts (very few,
perhaps 4-5) on it. After verifying that the network is running
flawlessly on the new 'temporary' server, I proceed to format the old
one and reinstall everything.
Now, onto the problem: it was late and I was tired, and I stupidly
fo...Transfer of email server.
I am in the process of setting up our exhchange server. I am almost finished
creating all mailboxes. All emails were being handled by an external company.
I would like to know what would be the best way in transferring over everyone
to the internal exchange server.
Just looking for the best solution for this.
apereira <firstname.lastname@example.org> typed:
> I am in the process of setting up our exhchange server. I am almost
> finished creating all mailboxes. All emails were bein...last downloaded date and balance
After I import my bank's OFX file, the balance and date
under the "Downloaded:" title at the top left corner(while
viewing my account), do not update to the most current
I looked into my bank's OFX file. The XML seems have the
necessary information to update the downloaded balance and
It used to work before. It seems to have stopped updating
after my bank changed formats from OFC to OFX. I am not
Any help is highly appreciated.
I am experiencing the exact same problem. Please let me
know if you find a solution.
>-----Original M...News server name for software testing -reg
Like msnews.microsoft.com, I need the News server for winrunner (Automated
software testing tool), to configure in the
Try posting this in an Outlook Express news group - this is not one of them.
Outlook is a part of Microsoft Office and is what this group supports.
Outlook Express is a part of Internet Explorer and has its own news groups.
You can also find some good Outlook Express information here:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolici...OWA 5.5 failed to connect to the microsoft exchange server Messages
OK, here is the issue..
OWA 5.5 works great for users that use Outlook 2000 (or Lower version), but
the uses that are using Outlook 2003, they are getting the "failed to
connect to the microsoft exchange server" error when attempting to access
the mail via the OWA page.. I've searched and searched for this one.. any
answers.. and no, upgrading the server to 2000 or 2003 isn't a option right
Thanks for your Help
HAve you applied all the post SP4 fixes for OWA that address OUtlook
On Wed, 2 Mar 2005 15:33:02 -0800, "Paul Stone"
<T...Find the last, 2nd last and 3rd last data in a column
I have data listed in several colums and need to create a formula to
detail the last (most recent) 2nd last and 3rd last piece of data in
I have used the following formula to display the last but cant edit
this or create another formula to get the 2nd and 3rd last pieces of
Thanks in advance
If there are no empty cells in the range:
last cell: =INDEX(A:A,COUNTA(A:A))
Bernard V Liengme
Microsoft Excel MVP
r...E2K3 SP2 : How to move public bank to another server ?
I post this message because i've a problem without solution now with my
exchange 2003 std sp2 server.
I've actually on this server a public bank, with public folder hierarchy
and publics folder. This server start to be old and i would like to transfer
everything to another server, but i didn't found how to do it.
I just founded informations on how make a replication of a public folder
and a way to transfert public bank to another by doing a sort of emergency
But is it any clean way to do it (transfert hierarchy and publics folders
with conte...how to reset 'last row'
Something that's been puzzling me since I started using Excel (currently
Office 2000) is the following:
Ctrl-End goes to the last cell (row/column) of a sheet. I use it a lot to
select the remainder of a sheet.
However, when I've deleted rows at the end or columns at the right, Ctrl-End
still selects the highest row/column that has ever been used in this sheet,
even if it's way beyond the point where the sheets ends now.
Apparently, Excel has an internal 'last row' ahd 'last column' value for
Is there any way to reset these values to where the sheet re...sql sp4 to server
If I apply sql 2000 sp4 do I also need to apply sp4 to the desktop engine on
my laptop clients using outlook client?
I meant to say that If I apply sql sp4 to the CRM server (which is running
sql locally) will I also need to aplly sp4 to the MSDE instances on my laptop
users PC's using the Outlook client? Sorry just a little anxious\nervous
when it comes to CRM 1.2. Trying to get to CRM 3.0
> If I apply sql 2000 sp4 do I also need to apply sp4 to the desktop engine on
> my laptop clients using outlook client?
Yes sp4 is required for the msde. ...