CRM 4 and SQL upgrade
I have a CRM 3 installation on a SQL 2000 box which is also the CRM app
Planning for the CRM 4 upgrade, I have a new physical server with SQL 2005
What is my most efficient upgrade path?
I think you can do the following:
1. Move the CRM 3.0 database to SQL 2005.
2. Point the CRM 3.0 application to the new database server. (There's
documentations on how to move database to a new server on the
3. Install/Upgrade CRM 3.0 to CRM 4.0 on the CRM 3.0 application
I think this is the fastest and easiest in my opinion.
Darren Liu, Microsof...AVERAGE function returns #DIV/0! error
I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
Is there a safe proof way to omit the invalid values out of the average
Try this. I assumed your range was A1:A10, change this to fit your data.
Enter this formula by using CTRL+SHIFT+ENTER as it is an array formula:
> I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
> Is there a safe proof way to omit the invalid values out of the average
social security number has 7 numbers. However, when I type
0454636, 0 will be gone.
Ex: Type 0454636. It will become 454636.
I have almost 8 columns stored social security numbers.
Please show me how to fix the problem.
Try format cells -- custom and type 0000000 in the box.
>social security number has 7 numbers. However, when I
>0454636, 0 will be gone.
>Ex: Type 0454636. It will become 454636.
>I have almost 8 columns stored social security numbers.
>Please show me how to fix the prob...Remove Duplicate Calendar Entries?
Is there a script to remove duplicate calendar items in Outlook 2003? I
can't see how people charge $40-$80 for a one time program.
AdoboBoy <firstname.lastname@example.org> wrote:
> Is there a script to remove duplicate calendar items in Outlook 2003?
> I can't see how people charge $40-$80 for a one time program.
If you want your duplicates removed badly enough, you'll pay for a program
that does it. It is often not a one-time occurrance. Many of us, though,
just delete them manually. It's really not very difficult unless you have
hundreds of them.
...Pivot Tables #4
When I double click to drill down to the supporting data
in a pivot table, the data is displayed on a new tab
within the workbook. Then to close that data, I have to
delete the tab.
1) Is there a faster way to view then close the data
without having to delete a tab every time?
2) If I leave the new sheet open, is it linked to the
pivot table? In other words, if I refresh the pivot
table, will the data on the new sheet be automatically
refreshed as well?
#1. I don't think so. But maybe you could apply Data|filter|autofilter to the
original da...Cannot boot, setup cannot detect existing installation
After being infected by a virus (cleaned from via anti-virus bootcd)
my Dell XP machine no longer boots. Trying to boot in safe-mode stalls
after the line that says that it is loading ACPI.sys. I tried to do a
repair from the windows XP setup CD but it fails to detect the
existing installation. I don't know if it makes any difference but
there are 3 partitions (C:, dell utility and dell recovery).
Since it seems to loading the other 'sys' files before ACPI I assume
that the bootloader sequence is okay (MBR, boot partition, etc) and
the problem lies with system files.
I...Out of Memory #4
I have an application that is used by over 8000 users worldwide. There
are several that are reporting an "out of memory" problem using one of
the functions in the tool. One user just received a brand new laptop
(T41) and is now encountering this error. It was working on their old
laptop. The function that they are trying to run when they get this
problem opens up another excel spreadsheet and then selects sheets from
the first spreadsheet and then copies it into the second spreadsheet.
It goes through a loop and does this for each sheet. It is only
copying the values and forma...SystemParametersInfo(SPI_GETWORKAREA,0,&o_Rect,0);
Im trying to make my GUI controls monitor display format settings
independant. I put a CButton control on the so called "work area"
I do :
x = o_Rect.Width ();
y = o_Rect.Height ();
o_Verwijderen.MoveWindow(10,(int)(y * 0.82),o_Rect.Width
My CButton is called o_Verwijderen and i put it on 82% of the y ...great palins 8.0 us payroll
can i see a traning demo session on us payroll 8.0
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
having trouble finding the proper spreadsheet for windowsXP...I HAVE A XLS FILE TO OPEN, anyone used a spreadsheet, that could direct me? Thank you
Windows XP is an operating system. You also need to have a version of
Excel as well.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"rick" <email@example.com> wrote in message
> having trouble finding the prop...2007 print merge 4 postcards/4 different addresses per page
I have read the previous posts regarding this issue. I cannot resolve my
I have created a 1/4 page postcard. Information on page one and successfully
merged addresses on page two. I only have one postcard on my screen and as I
scroll through, I see all the correct information in the merge.
I am having trouble printing the merge. I want 4 postcards on one 8 1/2x11
piece of cardstock. One side with the same information and the other side
with four different addresses from my merge. I am getting side one with
information and side two with four duplicated addresses. The second pi...delivery restrictions #4
I have a mailbox that is used only to receive fax attachemnts emails from a
service that a phone company provides us.
I want to allow only emails coming from this domain
(*@voicemail.telepacific.net) to be allowed in this mailbox.
How can I chieve this? The delivery restrictions area allows only specifying
internal addresses but the address I want to allow is external.
On Thu, 10 Aug 2006 19:28:32 -0700, "Perecli Manole"
>I have a mailbox that is used only to receive fax attachemnts emails from a
>service that a phone...Great Plains 8.0 Macro
I am trying to learn how to write different Macros in GP. I recently
mastered the old "Mail Merge" and I would like to take it one step further.
Is it possible to add an "IF, Then..." statement to the macro? Sometimes when
changing Standard Pricing a Pop-Up Box Appears and Other Times it doesn't, so
I would like the macro to see if it's there and click OK, otherwise, just go
on to the next thing.
Second, I would like to be able to write the results to a log file. For
example, a Part Number goes through add it to the log file with an OK,
another ...Error 4.4.7 -
We are not able to deliver mail from our Exchange 2003
server (part of SBS) to certain domain names including
hotmail.com, microsoft.com and msn.com. Here is the
messages that we get.
First message from Exchange..
This is an automatically generated Delivery Status
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
Contents of attached text message (ATT04044.txt.) sample.
Final-Recipient: rfc822;Gary.Megson@fds...please help #4
Please guys I really need some help with this, I'm at my witts end.
We are using sbs server 2000 with exchange. If and email is sent to one of
our users say firstname.lastname@example.org with an other address in either the to/
cc/bbc fields, say email@example.com. Exchange is routing the
same email from the orgianator (spoofed) to the second address. so that the
other address recieves two copies as if from the original sender, but it
your servers that are send it out.
Now I'm asssuming this is a relay problem, but can not find any why of
Your help would be greatly ap...NDR 4.4.6?
I get the following error when attempting to send to a particular DL.
A configuration error in the e-mail system caused the message to bounce
between two servers or to be forwarded between two recipients. Contact your
How do I check the possibility of looping?
Do the users in the DL have forwarding turned on within their mail
properties in AD?
"pscottlee" <firstname.lastname@example.org> wrote in message
>I get the following error when attempting to send to a particu...Using Fintech with GP 9.0
We are going to be using Fintech to pay for alcohol purchases via EFT, has
anyone discovered an easy way to set up EFT vendors? all I can find info on
in the help file is European EFT.
Open one of the EFT setup windows and click on the Help button within
the window. The correct EFT help will open.
Frank Hamelly, MCP-GP
NOVA Solutions LLC
...Changing user business units = authentication error in CRM3.0
When we change a business unit for a user (and assign the appropriate
roles�) the user is unable to signon to CRM. The user is signed off of
crm before we change the BU. We have had them reboot and try to sign
on and cannot. They get an error which indicates the user is unable to
authenticate. When we do an IISReset on the CRM server the user is
then able to signon to the new BU and everything works fine. This is a
problem because we do not want to kick everyone off the server every
time someone changes business units. Please help�
Remember when you change a BU, their security roles get dro...error #4
no se me instala el excel, ser� la versi�n antigua que no me deja?
...10.1.4 can't find an installation???
I have Office X SR-1 installed, and whenever I try to upgrade to the 10.1.4
(Exchange update), the installer fails telling me it can't find a valid
installation to upgrade. Office is located in the Applications folder of my
hard drive and is a legal copy, so I don't know why it won't install?
Thanks in advance!
On 10/3/03 8:35 PM, in article BBA3B855.28Eemail@example.com,
"Mailinglists" <firstname.lastname@example.org> wrote:
> I have Office X SR-1 installed, and whenever I try to upgrade to the 10.1.4
> (Exchange update), the installer fails tel...column width #4
I thought it would be much easier but I can't set column widths from VB
After lot of trouble I find out that ColumnWidth is not what I need, i
sets width in characters not in pixels. How can I set width in pixels
I need full synta
AFAIK the width property is read-only. So you can only use ColumnWidth
> I thought it would be much easier but I can't set column widths from
> VB. After lot of trouble I find out that ColumnWidth is not what I
> need, it sets width in characters not in pix...File Permissions
I'm trying to setup file permissions on a single file shared on the server,
whereby the Admisitrator has full control, but certain users have 'Read' only
I want users to be able to access the file and read the contents, but no be
able to modify or change the contents.
Simple enough, but within the file's Security tab I have the Administrator,
and Users group added (nothing else), and permissions are set to Full control
for Administrator, and Read & Execute, and Read for the Users.
However, the users are unable to open the file (Access Denied), unles...templates #4
template won't come up after download, a validation succuessful screen
appears and I can't find downloads>?
Why don't you give us more details, what template are you downloading and
from where, exactly - give us the entire url.
If this helps, please click the Yes button.
> template won't come up after download, a validation succuessful screen
> appears and I can't find downloads>?
Does anyone know if this message has a specifiv meaning or is it just a
"catch all" mesage?
It is the status that is returned when I try to emial a specific domain. I
am trying to find out if my domain has been blocked, because I cannot emial
anyone from that domain, from my domain.
Anyone have any idea how I can determine if we are blocked?
Numeric Code: 4.4.1
Possible Cause: The host is not responding.
Troubleshooting: This code may be caused by transient network conditions.
Exchange will automatically try again to connect and deliver the e-mail. If
delivery sti...Removing permissions of Deleted objects
I am running Exchange 2003 and am trying to remove some deleted users
permissions from the Org level of Exchange in the ESM. When I try to delete
the SID's, EMS generates a message saying that the rights are being
inherited. Does anyone know where I could find this, seems to me I am at the
top level. I have checked delegation and the objects do not show up there.
In Security\advanced of the Org object they are listed as being inherited,
but I can't find them anywhere else. Any idea's out there? They are just
appearing as sid's as they are old user objects that have...