Changing SQL Server for CRM 1.2
As my SQL server is currently on its last breath I am in the process of
moving our CRM 1.2 databases to a new dedicated serever. I have detatched the
databases from the old server, copied the files to the server and attached
I have then gone into CRM deployment manager and changed to the SQL server
to the new server.
That all appears to work fine, no error messages. But when users try to
access the CRM system they get an error and the CRM server event log fills
with error messages. A few are listed below:
dmLog: Failed to execute the SQL batch in the file sqlbatch.sql.
MSCRM P...Can't insert Char(1) into SQL Server from Stored Procedure
I am trying to insert a char(1) field into a table from an ASP.Net/C#
At first I was inserting rows into the table but none of the columns that I
was inserting the rows into were char(1) columns, they were mostly int and
Then I found out that there was one column in the list that was not supposed
to be an int column but instead it was supposed to be one of the char(1)
columns into the table.
So I replaced the int column in the list with the char(1) column and since
the value of the char(1) column resulted from a CheckBox ('Y...Outlook plug in install
I currently have SQL Server installed on my local pc for
some other task. In the install of Outlook plugin for CRM
it wants to install MSDE is this going to conflict with
my SQL 2000 instance?
Joe Thomas wrote:
> I currently have SQL Server installed on my local pc for
> some other task. In the install of Outlook plugin for CRM
> it wants to install MSDE is this going to conflict with
> my SQL 2000 instance?
Yes it will conflict. Microsoft will not support sales for Outlook if
you do this and they strongly recommend not to install sales for
Outlook if you already have SQL ins...How do you turn off/on the "1" or "2" or "+" or "-" view hide/unh.
What is or how do you control, turn on/off the small "1" "2" or "+" "-"
hide/unhide view buttons right above the "A" cell? Sometimes shows when I
'Data - Goup/Outline'
> What is or how do you control, turn on/off the small "1" "2" or "+"
> "-" hide/unhide view buttons right above the "A" cell? Sometimes
> shows when I hide columns.
You can toggle them to hide or display with
How would I update a column with numeric values so that there are 3 leading
zeros for each row?
it is not possible to add leading zeros to a numeric value. Mathematically,
this is redundent and unnecessary.
> How would I update a column with numeric values so that there are 3 leading
> zeros for each row?
hit the post button too quick.
option 1. custom format
if your numeric value is 12345 then see the custom format to 00000000.
note. format do not change data - it just changes the way it looks in the
option2. format to text
then use the c...Meeting updates #2
My users cannot update meetings created when they were on
the old email server. I have noticed that the old string
is still mapped to the meeting. e.g
x400;c=us;a= ;p=Org name;o=exchagne;s=Lastname;g=firstname;
Take a look at the following article:
275134 XADM: Cannot Reply to Messages That Are Sent from a User Account That
The same thing applies to meetings.
How did you move them and what version(s) of Exchange?
Microsoft Exchange Support
This posting is provided "AS IS" with no warranties, and confers no ri...How to install WCF templates?
How to install WCF templates for Visual C# 2008 Express Edition?
I have Visual Web Developer 2008 Express Edition too and my computer is
running on Winodws XP Professional. I can find WCF template in VWD2008EE but
not in VC#2008EE.
Any help would be appreciated
On Apr 15, 1:55=A0pm, Raj <R...@discussions.microsoft.com> wrote:
> How to install WCF templates for Visual C# 2008 Express Edition?
> I have Visual Web Developer 2008 Express Edition too and my computer is
> running on Winodws XP Professional. I can find WCF template ...Money Plus not Updating Quotes
For the past couple of days Money Plus has not been automatically updating
stock quotes and manual quotes does not work either.
I should add that this problem has been intermittent for the past couple of
In microsoft.public.money, D.Duck wrote:
>For the past couple of days Money Plus has not been automatically updating
>stock quotes and manual quotes does not work either.
>I should add that this problem has been intermittent for the past couple of
High server loading. Try again later.
In microsoft.publi...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...Service Products Tracking.
We run a workshop repair service, what is the best way to track customers
products, as it seems unfeasible to add products when booking an over the
counter repair order in CRM.
I would like to track repairs against machine manufacturer to do simple
reporting like reliability against brand etc.
I would recommend the following as the product you sell is a service I would
create the service as the product i.e. create product Start-up costs, hourly
To track brand reliability I would create one or more custom entities which
contain the brand and maybe even their products. T...Comments to print on invoices and packing lists
We have a client with a specific need for printing customer comments
and item comments:
1) They want to store comments on Customer Master. When a sales order
is entered these comments should default on the sales order with an
option to change. They want to mark these comments to be printed on
sales order, invoice, packing list and pick ticket.
2) Items are stored with item specific comments. These comments need
to come to the sales order when the order is entered with an option to
change. They want to setup comments with similar setup where they
print on order, invoice, pick ticket and packi...Outlook Rule to Forward with Secure Delivery
I need to automatically forward messages to an outside vendor with secure
delivery. I'd like to set up a rule to do this for me, but I'm not finding
away to be able to forward the message using secure delivery. Can you please
tell me how to do this?
ChrisH <ChrisH@discussions.microsoft.com> wrote:
> I need to automatically forward messages to an outside vendor with
> secure delivery. I'd like to set up a rule to do this for me, but
> I'm not finding away to be able to forward the message using secure
> delivery. Can you please tell me...attachment previewers not installed?
I have a newly installed Office 2007 and cannot open several attachments ie
WMV as I get a message "no previewers installed" How can I resolve this
do they open if you double click them? The previewer error is because they
can't display (or play) in the preview pane - you need to open the
Are you using Vista or Windows XP?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
daily...2 Domains, 1 Exchange Server
We're trying to go with 2 seperate 2003 domains, but with only one
Exchange 2003 Server. What would be needed for the domain that the Exchange
server is not in to access e-mail? We've contemplated having those users use
OWA, but would really like them to be able to use Outlook 2003. We're a
school district and want to segregate the kids domain from the administration
domain, but only have funding for one Exchnage server. Any ideas\help will
be appreciated. TIA.
This should explain what it requires:
"tj woo...RMS 1.2 vs 1.3, plus integrate with Great Plains
1.) I am working on an assessment for upgrading our current RMS software from
1.2 to 1.3. My assessment will take in account the benefits, broken down by
store operations (Retail) and the benefits to IT. Also, list risks and
potential problems that might be experienced. We currently have 28 stores
with 3+ registers per location with another 22 new stores on the schedule
over the next 2 years. Are their other in this group of similiar size that
have done this upgrade to the new version?
2.) If we do not upgrade the software, can we still integrate the RMS to
Great Plains? Would we...Online Price Updates
Somehow online price updating was turned on in my file. I have turned it off.
However, when I go to delete the erroneous past-dated Online Prices for a
particular stock, it appears they are initialling deleting, but when I return
to the stock later, all the deleted online prices (from the past) are
re-instated. It is as though none of the price deletions I performed have
How do I clean up these erroneous past online price updates?
...Symbol Updating Only Every Few Days (if at all)
Using Money 2006, and have a symbol "VLO" that is only updating every few
days. This stock was a duplicate (downloaded transaction created a new
version of the same stock - my fault not clicking correct choice when asked).
I've removed the symbol from the stock entry that was downloaded, renamed
this entry to something bogus, deleting this renamed stock "from all
accounts", then added the symbol back to the original VLO stock that I've
been tracking for years.
Now the stock just says "unch" in the portfolio view, and the price history
is only updat...how to install Microsoft Mail to Outlook 2003
I found 'this' (http://www.outlook-tips.net/howto/msmail.htm) on
I don't know if it works...
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
...Word 2003: Will it work on Windows 7 Pro
The ads say there is virtual XP on Windows 7 that can run programs like Word
2003. In your experience is this true? On any Windows 7 machine? Does 64
versus 32 bit processor matter for either Word/Office 2003 or Office 2007?
You don't need Virtual XP to run Office 2003 on Windows 7.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"removing all headers and footers"
<email@example.com> wrote in message
news:95298031-44F6-4E74-A608-C76987DFAB46@microsoft....MS CRM Security 05-26-04
I have 2 business units:
1. New Business Sales
2. Account Management (management of current customers)
I want to use the MS CRM security settings so that users in New
Business Sales cannot see any account records for our current
customers. This includes if the New Business Sales users select the
‘All Accounts’ view.
Is this possible with MS CRM?
Yes. When you assign access rights to the role, only give them "Business Unit"
access, they will only be able to see data within their BU.
------------------...Taste this important update
Content-Type: multipart/related; boundary="uessxwmvq";
Content-Type: multipart/alternative; boundary="mweirjjojzzphfh"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to m...Updating External Links Excel 2000 vs 2002/2003
I have a situation where I'm using Excel 2000 with a
workbook containing references to another workbook. When
opening the first workbook & the second workbook is not
available, you can say "no" to the update external links,
and still see all values as they were when the first
workbook was last closed.
However, when the same workbook is opened in Excel 2002 or
2003, the external links specified only as a cell reference
show the proper data (e.g, =wbkname!E1), but when they are
Excel formulae (specifically a SUMIF), I'm getting a #VALUE!
error in the pertinent cells
Is th...Outlook will not run in Cached Exchange mode
This is a multi-part message in MIME format.
Having a problem running outlook offline. I can't. I keep getting an =
error that outlook was unable to open my .ost file when I try to run =
outlook while not connected to my exchange server. So I set Outlook not =
to run in cached mode, deleted my .ost file, reset outlook to work in =
cached mode. Outlook creates the ost file, but still every time I try to =
run outlook offline, I get the same erro...distibution list / updating
when we update our contacts how can we get outlook to
update our distribution lists at the same time.
What do you mean exactly? Can you give an example?
Also what version of Outlook are you using?
>when we update our contacts how can we get outlook to
>update our distribution lists at the same time.
That's what the Update Now button is for.
"wayne" <firstname.lastname@example.org> wrote in message
I am having major issues with IE8 recently. I get no error messages, things
just don't work. For example, I can't download files from sites, windows
update will not download files either. I viewed the html source on a
particular page that wasn't working and there was some text in the html that
FWIW, I have now installed both chrome and firefox and they don't have any
This problem started after I switched from McAfee to...