Move databases from WSS SQL Express to Full SQL?
Is there a procedure to move a WSS SQL Express database to another server
running SQL Server?
Yes there is a process needs to be followed:
Detach the content Database from SharePoint Web application through Central
Move LDF and MDF files to the new Server
Attach the Content Database from new SQL Server (There is a option to
mention Database Server and DB name when you attach)
Make sure your Farm account has DBCreator and Security Admin roles in the
new ...Going Live with GP
I plan to start using GP Sept 1. We have not transferred any historical
transaction from the old accounting system.
All of our Vendors, Customers, Inv Items etc. are entered and we have tested
all functions of AP AR GL.
Does anyone have a checklist of things to do when starting with a new GP
I understand the basics things such as
Enter open invoices in AP and AR
Enter open POs
Enter begining GL account balances fromt the old accounting system
Begining bank balances and so on.
I just want to make sure that I'm not overlooking something so a check list
from someone ...SOT
This is a multi-part message in MIME format.
Is it possible to use non-Exchange Mail servers with Outlook (I'm =
thinking of the free Mercury that comes from Pegasus initially - are =
there others?) and if so, are there any recommended web sites to tell me =
both how to set up the mail server and also connect Outlook to it?
Interim Systems and Management Accounting
------=_NextPart_000...Migrating data from GP to GP
I have a GP7.5 installation when all data is, and a new GP8 installation on
a different server.
I need to migrate inventory data from the GP7.5 to GP8.
I know that i should use the integration manager. But using it means that i
should know the data source structure which is GP, and this is very complex
because i need to migrate all inventory module, not a few data.
PS: i don't what to make an upgrade because other modules are different in
the 2 installations.
Does anyone have any idea on this issue?
Have tried just using DTS within SQL Server choosing your 7.5 s...VISIO 2000
using SP 2
Appqarently I can't set the metric system via
tools | options | regional settings
Well, that is, I *can* change the setting to 'centimeters' -
but then .. nothing happens, everything is still in inches..
This is a confusing dialog. The setting controls the units for the next
drawing you create, not the current one. Go to File > Page Setup to modify
the current page.
This posting is provided "AS IS" with no warranties, and confers no rights.
"ep" <anonymous@t-online....Exchange Server Tab
I am running Exchange 2000. How do I get the Exchange Server tab to display
under Active Directory for Users and Computers?
How do I get the Exchange System Manager snap-in?
you need to install the ESM on your workstation...see this:
"Diane Walker" <email@example.com> wrote in message
> I am running Exchange 2000. How do I get the Exchange Server tab to
> under Active Directory for Users and Computers?
> How do I get the Exchange Sy...GP concurrent user and SQL 2005 CAL
assuming a 10 con-current licenses being installed on 15 workstation, with 15
users in GP.
How many SQL 2005 CAL is needed ?
Server plus user client access license (CAL) licensing requires a separate
Server license for each server on which the software is installed, plus a
user CAL for each user accessing the server.
The user CAL model will likely be more cost effective than device CALs if
there are multiple devices per user (for example, a user has a laptop and
handheld computer accessing SQL Server).
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business...Re-Installing Excell 2000 on new computer
I purchased Excell 2000 and installed on Dell 8200
w/windows ME. Hard drive crashed. Aquired new Dell 8300
w/ windows XP. Trying to install but windows will not
except product key. "Can't find previously installed
program on system". Any help would be greatly
You are presumably using an Upgrade version which requires that you ca
prove ownership of a prior version. You can use any setup disk (CD o
floppy disk 1) containing a qualifying Microsoft product and refer th
new setup to that. I think you get the option to browse with the "no
found" message...Questions about GP Client upgrade configuration
I'm getting ready to install a Service pack for GP7.5 and my ultimate goal
is to get ready to upgrade to GP8.0. However right now upgrades are very
tedious and below is the whole story.
All the users/clients are identical!
Let me describe what we have done in the past to upgrade and what I want in
In the past we sat down at each client machine performed the install. Then
we logged in as an administrator (Ethoseries required this I think) so the
product can finish loading what it needs. Again we do both steps on every
In the future what I would like to do is in...Error: "Unable to open your default e-mail folders. The microsoft exchange server is unavailable"
I have a user on our exchange 2003 sp1 system who is receiving the
above error when trying to connect to his mailbox. He is able to
connect in OWA. I gave myself rights on his mailbox and set up a new
profile on my machine (xp, office 2003) and connected fine. I then
logged in as his account on my machine, set up a profile and tried to
open outlook and received the error above.
Any ideas. Not seeing this exact error on the microsoft site or google
...Multiple aliases in Exchange 2003
I work for a company that provides both internet and television service. We
run aan old version of qmail for our email server.(This is before I started
working here) Recently the two areas split and formed two seperate companies.
I am with the TV side and am in the process of moving us to Exchange 2k3.
There are two employees of the internet company that helped found the overall
company, that do not want to loose their email addresses and aliases.
I have created domain accounts for them, but do not give them their
passwords. I then created a contact to forward the incoming email to....Server info
I've been having a problem sending emails from my Windows account. I found
the problem (I think). In the account information area, the information is
now incorrectly listed as POP3 when it is actually imap. However, when I am
in the tab where this is speciaifed, I can't change that info in the box - it
will not allow me to type in the box or to delete the POP3. I need help!
You cannot edit the protocol specification. Delete that POP3 account,
restart Windows Mail, then recreate the account with IMAP protocol.
Gary VanderMolen, Microsoft MVP (Mai...Fabrication and GP
I need to know how to process a transaction in GP. We are a sales -
distribution center. We do some light fabrication. We need to find a way in
GP to take one part or more parts, do fabrication work with them, then put
them back into the system as a new part. For example, we take drum rollers
and send them to a local fabricator who drills holes in them, inserts
"brushes", then sends them back to us as a brush roller. They charge us for
labor and the additional material and we have a new part.
Currently, we either treat it as a parts sale / purchase. That part is
clean, but a...Exchange server being compromised???
Our company has an Exchange 2003 (SBS 2003) box that's SENDING out mail to
mxi.earthlink.net and mx2.earthlink.net and takes up the whole T1 bandwidth
since last week. We've ran antivirus and found several spyware but that's
about it. We've also ran packet analysis to confirm those two addresses but
now we're stuck as to how to solve this. Can someone lead me to the right
direction as to what or who is relaying our smtp traffic? Please help. Thanks.
Exchange 2003 is closed to relaying, unless you've enabled it...what IP
addresses are the emails coming fro...Upgrading from GP 9 to GP 10
While trying to upgrade from GP 9 to GP 10, I get an error when selecting
the instance of the already installed GP 9: "Index was outside the bounds of
the array". Any ideas?
...GP 9 Upgrade and SQL Server 2000 sp4
per microsoft's documentation sql server sp4 must be installed before
upgrading to GP 9. does anyone know if the sql server sp 4 install is
necessary for the GP 9 upgrade? microsoft's documentation indicated that all
service packs for GP 8 must be installed before upgrading to GP 9, but after
speaking with support, they said the GP 8 service packs aren't necessary.
bottom line: i'd like to avoid the sql sp4 install if necessary as i had to
rebuild my test server after installing sp4 last week.
Since the database requirements for GP 9.0 list SQL 2000 SP 4 a...Payroll GP 10.0
Got this from a client and not sure what they are doing, but never heard of
this any help would be great.
As I am reviewing the Payroll Deduction Journal from the payroll I just ran
yesterday, I have identified 5 employees whose deductions & benefits did not
calculate. I happen to be one of the 5. There is $$$$$ that did not come
off my pay as deductions; including my 401K. The common denominator seems to
be when employee changes are made, deductions & benefits are made inactive;
even though those benefits & deductions have no part in the changes being
made. Pardon me, ...Security Update for Windows Server 2003 (KB956744) Cannot Install.
For Windows Server 2003.
This is a standard Windows Update that I try to install but get a message
that it failed to install. I can't find any source to tell me why it won't or
what I can do about it. I am not getting an error code of any sort - it is
just listed under "not installed" when I get my update installation screen at
the end of the installs.
Can anyone help please?
I downloaded the update manually from:
Ran it, and then ran Check U...MS CRM integration to GP
Can any one update me wheather the mutiple company
databases can be integrated to MSCRM.
The senario is this.
a company has mutiple entities using GP 7.5 and unique sql
databases,require to integrate mscrm with gp.
The integration that is supplied by MS only allows you to integrate
with 1 company DB. You could probably use some of the components that
are provided, but you will need to develop some of the integration
logic yourself to address this.
On Sat, 24 Jan 2004 05:34:31 -0800, "firstname.lastname@example.org"
&g...How do I catch orchestration exception using eConnect 8.0
Hello, the exception I am getting in Biztalk Health & Activity Tracking:
Microsoft.GreatPlain.eConnect.eConnectException: Sql procedure error codes
Error Number = 7149 Stored Procedure taRMTransaction Error Description = The
entered(SLPRSNID) does not exist in the Salesperson Master Table.
How do I catch "Microsoft.GreatPlain.eConnect.eConnectException" in my
Thanks in advance for your help.
We do not suggest, nor supp...error in GP
When I try to generate a Historical Aged Trial Balance my computer freezes
then gives me this error message. "The stored procedure
pmHistoricalAgedTrialBalance returned the following results DBMS:208, GP:0
This is path I use to get to the report: Reports/Purchasing/Trial
Balance/Historical Aged Trial Balance.
We have been having problems with other reports because of the change from
2005 to 2006.
I appreciate the assistance.
This is Lisa. Thank you for your inquiry on the Historica...Convert 2002 D/B to 2000 shows no details
When I attempt to use the [Tools];[Database Utility]; to
[Convert Database]; to Access 2000 format from Access XP,
the resulting database doesn't display anything in the
Detail View. All tables and queries appear to be present
in LIST View and ICON Views but when DETAIL View is
selected the entire display is blank.
Is there a "Select Details" option in Access as there is
in Windows Explorer?
"Tom" <email@example.com> schrieb im Newsbeitrag
> When I attempt to use the [Tools];[Database Utility]; to
> ...Moving Exchange server to another domain
I would like to get information about moving an exchnage server from
one windows 2000 domain to another new domain, as a part of moving W2K
domain from domain1 to domain2.Please help me by giving real idea how
i have to start and what are the precosions i have to take. The real
need is to move two existing win2k domain to a new domain.
That is EXDM1 and EXDM2 have to restructure and form NMDM1.
According to my idea,
1. start by joing a new server to existing forest and promot it to DC
with domain name NMDM1.
2. Move the user accounts from existing two domains to new domain
using &q...GP General Ledger Distribution Reference Field Length
Is there a way of expanding the field length of the Distribution Reference
field beyond 30 characters?
No, I'm afraid it is not possible.
"Pam" <Pam@discussions.microsoft.com> wrote in message
: Is there a way of expanding the field length of the Distribution Reference
: field beyond 30 characters?
Just curious, why do you need a longer field length - for drill down purposes
or for report printing purposes?
> Is there a way of expanding the field length of the Distribution Refer...Autonumber Workaround with SQL Server 2005 BE
I built a multi-user contacts application as a split Access database
initially and then moved the back end to SQL Server 2005 using an ODBC
connection. I implemented an AutoNumber workaround to avoid primary key
collisions when users attempt to add records at the same time (probably
borrowed from Allen Browne or Albert Kallal?) by setting the default value of
the ContactID field = DMax("ContactID", "tblContacts") + 1 and trapping any
duplicate key errors as follows:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
On Error GoTo Err_Form_Error