Following are questions and issues that surfaced during the Existing Customer Roadshow Events. Thank you for your input, and we hope you find this collection of responses useful!
Q:
Is there
documentation that provides what User Fields are being used in new releases?
Is there a place that a User/Partner could go and find what User Fields are used
in general?
A:
As a rule, SL Development
should not be using User fields at all but using S4Future fields instead.
If S4Future fields are used, they should be documented in the schema help. If
someone finds a S4Future field being used by SL but is not documented as such,
they can file a bug so we can clean up the undocumented uses. As you know
though, just because a S4Future field is unused, it is not safe to use for
clients since we may use it in the future. If a client finds user fields being
used by the product (which normally are reserved for customizations), I would be
interested in what those are, especially if they are undocumented in the schema
doc.
Q:
Does Quick Send work with anything other than
Outlook email?
A:
Quick Send uses the
email capabilities of App Server. The App Server help states the following so
the answer to requiring Outlook (or Exchange) is yes.
profile (that is, the machine where the Application
Server will run must have a client installation of
either Microsoft Exchange or Outlook).”
Q:
Can invoices be processed (printed) using multiple
multi-currency formats? For example, can an invoice be printed in USD and
then turn around and print it in CAN?
A:
It can only be
printed in 1 format which is defined on the project.
Q:
When using multi-currency and an exchange rate
changes – there is a booking to Realized Gain or Loss account (RGOL) – does this
happen automatically or does one have to manually create the adjusting entry
into the RGOL account?
A:
The adjusting entry
is automatically calculated and the entry is created by SL for them.
Q:
Where can I find the following information?
Report Assistants
https://mbs.microsoft.com/customersource/news/report_assistants_msdyslv6.5.htm
SRS Benefits
http://www.microsoft.com/sql/technologies/reporting/overview.mspx
Product Life Cycle
http://support.microsoft.com/gp/lifeselectmonbus
Vendors Inactive
This is not a feature within 7.0
or 7.0 Feature Pack 1.
I would highly recommend that someone submits this
as a product enhancement.
This is not a feature within the
7.0 or 7.0 Feature Pack 1.
This is not supported by the controls being used
within Dynamics SL.
Q:
When you have a User home page and a Group home
page (and the user is assigned to this group), which home page takes precedence?
A:
The user’s home page
(as defined in User Maintenance) takes precedence.
Q:
Which reports were delivered in 7.0 as SSRS format?
A:
The following reports
exist in 7.0 FP1 in the SSRS format (Module -- Report name – Report file):
General Ledger – Trial Balance (01.611.00) – 01611a.rdl and
01611b.rdl
Inventory – Site Groups (10.870.00) – 10870.rdl
Order Management – Sales Orders Without Shippers (40.747.00) –
40747.rdl
Project Controller – Project Aging/Recap Report (PA.111.00) –
pa111d.rdl, pa111s.rdl, and pa111s.rdl
Service Dispatch – Service Call Invoice (SD.643.00) –
SD643.rdl
Work Order –
Reprint WO Batch Control Reports (12.010.00) – 12010.rdl
System Manager – Cover Page – 98991.rdl
Reports delivered in 7.0:
GL Trial Balance
Project Aging/Recap
Service Call Invoice
Sales Orders Without Shippers
Cover Page
Reports delivered in 7.0 SP1
Reprint WO Batch Control
Reports delivered in 7.0 FP1
IN Site Groups
Q:
Has the functionality changed which would allow
more than just the Business Manager and Project Manager to access the Project
Net Profitability functionality, if the user did not have to be assigned to the
Project Executive role?
A:
It appears in the
newest BP version that if the Employee ID is associated to the Project ID in
Project Employee Maintenance, or within Resource Assignment, AND if in the
Project Maintenance for that project, the “Available for all Employees to
Charge” checkbox is cleared, then it appears they do NOT have to be assigned to
the Project Executive role in order to review the project in Project Analyst.
Q:
What is the character maximum that one can use in
each header on the menu maintenance (i.e. Payroll menu documenting business
processes/tasks as we viewed within the 7.0FP1 sales image)?
Q:
Delegations within BP Project Time Entry – does
this exist? If not, are there any plans to have this as an enhancement?
A:
No, it doesn’t
exist at this time. It has been submitted as an enhancement.
Please go and vote on this
enhancement, if you would like to see this in the future (see voting
instructions).
Q: Do Column Headings come over when utilizing Copy and Paste within grids?
A:
No.
Q: Has there been a bug reported that upon deleting a User from the system that the access rights remain in the tables?
A:
At this time there has not been anything submitted
to Support and this could not be reproduced using 7.0 SP1 with SQL
Authentication.
If you can reproduce an issue like this, please
report the issue to Microsoft Dynamics SL Support.
Q: Does the Format Painter exist in SSRS?
A:
No.
Format Painter does not exist in Visual Studio.
Controls (textboxes, buttons, etc.) with similar
characteristics can be edited simultaneously by holding down the Ctrl key and
clicking on each field.
This will allow you to select multiple fields at
once, and then the properties can be edited.
All selected controls will be updated with any
property changes.
Additional tip:
If similar controls will be added, create one and
edit the properties as needed,
right-click on the control, select Copy,
right-click on an open area of the Layout tab, and select
Paste (or press Ctrl+V to Paste).
Q: Visual Studio – how do you get it? What does it come with?
A:
Visual Studio must be installed in order to use
Business Intelligence Development Studio.
Visual Studio can be purchased or Visual Studio
Express can be downloaded from
www.microsoft.com.
Business Intelligence Development Studio is a
component of SQL Server 2005 (or SQL 2000 sp2 or greater).
If Visual Studio is not installed, a Visual Studio
shell is installed with BIDS.
This shell would have very limited capabilities of
Visual Studio.
The components of Business
Intelligence vary depending on the edition of SQL Server being used.
Please see the Business Intelligence section at the
following link to compare features:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Q: Can Application Server provide more functionality when a manual step is required (i.e. Actuating the Okay button) if using the “Push the Freakin Button” product? If so, how can I get it?
A: Yes. PTFB Pro (Push the Freakin Button): http://www.ptfbpro.com/index.shtml -- $29.95
Last free
version of PTFB:
http://www.aplusfreeware.com/categories/util/system2.html
Q: Default password - any documentation on it that it’s blank?
A: We were not able to locate any documentation on this topic.
Q: FRx scripts – do you need to run these still?
A:
There are scripts that we are
familiar with that relate specifically to the FRx Financial Reporter piece,
separate from FRx Forecaster. These scripts are applied on the Solomon databases
when FRx is initially installed to allow FRx to run its server based indexing.
They should only need to be rerun if a new company or database is set up, or if
KeyChange is run to modify the account/subaccounts, etc. These scripts
would still be present with the version of FRx Financial Reporter that would be
used with SL 7.0.
Q: Does SSRS work with Visual Studio Express?
A: SQL Server Reporting Services can be set up to be used with Visual Studio Express. The Express edition would not provide all of the features of the full edition.
If using SQL Server 2005 Express, SQL Server 2005 with
Advanced Features and the SQL Server 2005 Express Toolkit must also be installed
in order to get the Business Intelligence Development Studio component.
Q: Question on SSRS management reporter – access rights – can you restrict by glaccounts?
A:
SQL Server 2005 Reporting Services uses role-based
authorization and Windows authentication to determine who can perform operations
and access items on a report server. Role-based authorization categorizes into
roles the set of actions that a user or group can perform.
All users interact with a report
server within the context of a role. A user can be assigned to different kinds
of roles for different items. For example, a user who is a member of the
Content Manager
role for one report may be a member of the
Browser
role for another report. Predefined roles are provided that group related tasks
into logical units. Examples of some of the roles that are available include
Content Manager,
Publisher,
and Browser.
You can create new roles or modify the existing ones to customize the tasks that
each role supports.
Role definitions are organized
into two categories. Item-level roles describe operations that affect reports
and other items that are accessed through the report server folder hierarchy.
System-level roles describe operations that are outside the scope of the folder
hierarchy. Examples of system-wide operations include creating and managing
shared schedules or accessing Report Builder, which are operations that can be
performed independently of any item. Item-level and system-level roles should be
used together in role assignments to provide a complete set of permissions
throughout the report server folder hierarchy, and across the report server.
The role assignments that you set
are used for all subsequent access to the report server, regardless of the tool
or approach used to access the server. Report server access through Report
Manager, Management Studio, the authoring tools, URL access, and programmatic
access through other applications is controlled through the role assignments
that control access to a specific server.
Security settings are stored in
the report server database. If you are configuring multiple report servers in a
scale-out-deployment, the role assignments that you define on one instance are
stored in a shared database and used by all the other instances in the same
scale-out deployment.
Additional Note:
Permission requests cannot influence the runtime to
give your code more
permissions than the runtime would have given your
code had the request not been made.
However, requests are what your code uses to inform
the runtime about the permissions it
requires in order to run.
To summarize, when designing the report, rights
should be granted for
full access to the report and then have
rights/permissions removed where necessary.
If role-based security does not allow data
field-level security (Restrict by GL Account), one option
would be to deploy multiple reports.
Use the initial report as a template and create new
reports
with where clauses on the SQL Query on the Data tab
of the report designer (Visual Studio).
Restrict access to each report based on the users
that can only see specific accounts.
Q:
FRx
Forecaster – Can you upload an entire projects’
budget?
A:
Data can be brought into Forecaster using a variety
of different methods. The Excel Add-In allows you to pull information from Excel
into Forecaster. You can copy/paste from Excel into Forecaster. There is
the ExpressLink which allows you to bring data from the General Ledger into
Forecaster. Also there is the Import Wizard which allows you to import data from
a file as well.
Q:
Doc Share – If you’re printing a report would you
also receive a copy?
A:
If Quick Send is configured then yes, a copy of the
document (i.e. Invoice) would be sent to the identified recipient within the set
up and a copy would also be sent to SharePoint once the Document Sharing is set
up as well.
Q:
In Hard CLOSE is there an ability to lock down
future periods?
A:
No.
There is only the ability to lock down prior
periods.
Please submit this as a product enhancement, or search to
see if there is an existing enhancement and vote on it.
Q:
Where do the overages go in task maximums?
(During the allocation process, task maximums are
identified and then booked to the task – but where does the overage get booked?
Is there an account code or glaccount / sub account
that the overage is booked to?)
A:
The overage gets posted to a designated (by the
user) adjustment account. We don’t stop posting or recording revenue. For
example:
Transaction is 12,500, and project maximum is 10,000.
We would post 12,500 to revenue, and -2500 to a revenue
adjustment account.
If another transaction comes in the following month for 1200,
we would still post 1200 to the revenue account, and -1200 to the revenue
adjustment.
Note:
Over the max transactions use the detail setup on
the Project Controller Setup – Bill To A Maximum Setup Tab.
Entries go to the PRPROJMX table.
Q:
EDI – Is HL7 supported in Dynamics SL 7.0?
A:
The SL EDI Transaction set consists of 850, 855,
856, 857, 875, 880, 940, and 945.
HL7 refers to health care transactions.
Data
is mapped for these transactions from the Standard file to conform to the SL
flat file format.
If there are HL7 transactions falling under this
transaction set, the data could be mapped to the SL format.
Q:
Are there inherent issues with upgrading BP when
setting up users?
Q:
Business Portal – does it work with any other
browsers?
A:
Business Portal for Dynamics SL supports only
Internet Explorer.
Q:
Invoices and other documents that are going to
Share Doc are in Word format.
Can they be in PDF?
A:
Currently, the functionality will only provide
copies in a Word format.
There is a product enhancement submitted for a PDF
format.
Search the Global Suggestion Tool on Customer Source and
vote for it.
Q:
Does Multi Currency work with requisitions?
Q:
Are there Hot Fixes for 6.5 Terminal Services –
graying out of screens toolbars?
A:
There are no submitted incidents or bugs in Support
at this time for versions 6.5 and up.
If you can reproduce this issue, please submit the
issue to Microsoft Dynamics SL Support.
A:
Yes, Multi Currency is functional within Flexible
Billings
Q:
Log out – menu maintenance.
Does the admin and/or each user need to do log out
after creating a new menu?
A: No, the users will not have to log out and back in – only the admin that is creating the new menus.
Q: 9/80 pay periods – can we accommodate?
A:
The current functionality doesn’t offer support to
9/80 pay periods
Q:
Multi Currency – Does it work within Project Flex
Billing?
A:
Yes, Multi Currency is functional within Flexible
Billings
Q:
Is there functionality to Quick Send in batches?
A:
No.
You can search customer source for Product
Suggestion.
If one exists, vote on it.
If one does not exist,
please submit one.
Q:
Search Servers – Server Express 2008 – are these
supported?
Q:
Where can I find more about FP1 features?
A:
For FP1 Highlights, go to the follow link on
Customer Source:
Q:
Payroll advice – document share (is this on the
table for future)?
A: Just to clarify, Payroll Advice is being sent via Quick send in the Feature Pack release. Just like we extended Quick Send with the Feature Pack, we will most likely extend Doc Share in the next release. We will take your suggestion into account.
Q:
Hard Close – this only works with posting to prior
periods.
Is it in the works to include future periods?
A:
Currently there are
no plans to restrict future periods. If this is a pain point for the
customer, please have them make this suggestion using the Product Suggestion
tool.
Q:
Does 7.0 FP1 require an uninstall/reinstall, or is
it just an install like a service pack?
A:
Feature Pack 1 requires an uninstall and reinstall.
There are many new features being added including new business portal bits.
Q:
Are the OLAP cubes within BIO for sale?
Q:
Item Line Request Requisitions – there was an issue
with sub account validation – Is this fixed?
Q:
Requisitions – will this ever be able to be done
within BP?
A:
No immediate plans to do this, but we are exploring
options.
Q:
Did Pay When Paid terms in AP come out in 7.0 or in
the Feature Pack ?
A:
In Service Contracts this was a feature in 6.5 and
in 7.0 we brought the feature as a term within Terms Maintenance.
Q:
Limitations to BP – Query export to Excel 1000
lines?
A:
It’s not really a
limitation to the export but a limitation in the Query page. When a Query
is run, only the first 1000 records are returned. Exporting the results
will only use the current result set.
Q:
Project Inquiry – does the grid sort work there?
A: At this time, grid sort works with in Task Net Profit Inquiry (PA.PND.00), Transaction Detail Inquiry (PA.TRD.00), Commitment Detail Inquiry (PA.CMD.00), and Assignment Inquiry (PA.RTI.00).
Q:
Set up screen – where is it for business date
security and hard close access?
A:
Business Date Security:
The Business Date (98.BZD.00) window is now
available only to the Microsoft Dynamics SL administrator role (SYSADMIN) by
default and to those who have been granted update rights for the window.
To grant access to the Business Date, open Access
Rights Maintenance (95.270.00) and add the screen 98.BZD.00 to the user or group
rights.
View rights will allow the user to see the Business Date.
Update rights will allow the user to change the
Business Date.
Hard Close Access: The hard close
option can be overridden in Initialize Mode.
If you choose to
prevent posting to prior periods in regular transaction processing, you can
designate individuals,
based on your organization’s business practices, who will have Initialization
Mode access rights in
the screens to override the posting restrictions.
Hard Close is activated in GL Setup in the Posting
Options area, but the Initialize Mode access is granted to the individual
screens where the Period to
Post is entered.
Q:
How do I get to the Dynamic Community?
A: https://mbs.microsoft.com/customersource/communities/
Q:
Quick Send ----Office 2007?
A:
Quick Send
creates Office documents in the Office 97-2003 format (for example *.DOC and
*.XLS).
Backwards compatibility of Office 2007 allows these
documents to be opened.
The System Requirements Guide states that Office
2003 and Office 2007 are supported.
For a full listing of requirements, go to
Link to SL 7.0 System Requirements Guide
Q:
Screen Dependencies document (i.e. batch release)?
Q:
Approval Hierarchy – Is this the same as it was
before?
A:
Yes,
nothing has changed on the approval hierarch (this includes Project Flex Time
(PFT)) process.
Q:
Can you see comments on the timecard preview?
A:
No, this is not a feature at this time.
Please submit this as a product enhancement as its
great feedback and could provide value!
Q:
Can the Menu items (specifically reports) be listed
alphabetically?
A:
Yes.
This can be done through Administration –
Maintenance – Menu Maintenance.
The menu items would need to be sorted manually to
be alphabetic.
·
In Menu
Maintenance, select the Group ID in the ‘Menu For Group’ field.
·
Select
the Menus tab and then select the module to be sorted.
·
Click
and Drag the module group or the individual module to the ‘Navigation Pane work
area’.
·
Click
the + to expand the module group or module
·
Right
click the menu option to move and then select Move Up or Move Down.
·
Continue
right clicking on each menu option and move them up or down accordingly.
Q:
Are there any recorded demonstrations available on
Customer Source?
A:
Not at this time.
Microsoft is exploring this as an option for the
future.
A:
Documents exported to Excel are created in the
*.XLS format (Excel 97-2003 format).
Backwards compatibility of Excel 2007 allows these
documents to be opened.
The System Requirements Guide states that Office
2003 and Office 2007 are supported.
For a full listing of requirements, go to
Link to SL 7.0 System Requirements Guide
Q:
Can the delete flag be moved or removed?
A:
The delete flag cannot be moved or removed from the
SL toolbar.
The SL toolbar cannot be edited.
However, the delete flag can be disabled by
removing the delete access rights for the user.
Q:
Does Application Server stop working with an active
screensaver on the workstation running Application Server on SL 7.0 FP1?
A:
No.
Application Server does continue processing with
the screensaver running in 7.0 FP1.
Q:
Do the BP reports run real time?
Q:
What are the steps to search for existing Product
Feature requests?
A: Sign in to CustomerSource at https://mbs.microsoft.com/customersource
Search for product suggestions using the Global
Suggestions Tool at:
https://mbs.microsoft.com/suggestion/suggestionlookup.aspx
On the Global Suggestions Tool page, enter the
following criteria:
Suggestion
Type:
Product Feature
Keyword:
Enter a word or phrase related to the feature you
are looking for.
Product Line:
Microsoft Dynamics SL
Optional –
After populating the Product Line, the screen refreshes to display the Product
Series (Financials, Distribution, Business Portal, etc.):
Select the Product Series
Optional – After populating the Product Series, the screen
refreshes to display the Product Module (modules available are dependent upon
the Product Series selected).
Click the Search button to return the results.
Note:
When the search results are returned, you can then
narrow down the search results
further by setting the Product Series and Product
Module on the Search Results page.
Q:
What are the steps to vote for Product Feature
requests?
A: Sign in to CustomerSource at https://mbs.microsoft.com/customersource
Search for product suggestions using the Global Suggestions Tool at:
https://mbs.microsoft.com/suggestion/suggestionlookup.aspx
On the Global Suggestions Tool page, enter the
search criteria to locate an existing product
feature request.
Once the product feature request has been located,
click the link to that request.
This will take
you to the Product Suggestion Detail page for the
specific request.
Click the “Vote for this Suggestion” button at the
bottom of the page.
After clicking the button,
you will be directed to a Thank You page.
Voting is complete at this point.
Example:
Voting for an existing Product Feature Request:
Global System Reversal.
You may remember discussing the Global System
Reversal.
Here is how you search and vote for that product feature
request:
Sign in to CustomerSource at https://mbs.microsoft.com/customersource
Go to the Global Suggestions Tool at: https://mbs.microsoft.com/suggestion/suggestionlookup.aspx
On the Global Suggestions Tool page, enter the following
criteria:
Suggestion
Type:
Product Feature
Keyword:
reverse journal
Product Line:
Microsoft Dynamics SL
Product
Series:
Financials
Click the Search button
The product feature request titled “Reverse Journal Transaction Batch” should be returned. Click the link to this. Direct Link to Reverse Journal Transaction Batch
To vote for this product feature request, click the “Vote for
this Suggestion” button.
Q:
What are the steps to create a new Product Feature
request?
A: Sign in to CustomerSource at https://mbs.microsoft.com/customersource
Go to the Global Suggestions Tool at:
https://mbs.microsoft.com/suggestion/suggestionlookup.aspx
Search for an existing product feature request
prior to entering a new request (for assistance on
searching, see the “Steps to search for existing
Product Feature requests” section).
Note:
Multiple votes on a single request is better that
multiple requests with less votes.
If you do not find the product feature in a search,
create a new product feature request by
clicking the “Create New” button (located just below the search criteria).
Q:
What are the Windows 2008 Requirements?
A:
File Server Requirements:
Microsoft
Windows Server 2008 Standard and Enterprise Edition (32-bit and 64-bit) (Note:
64-bit option supports Dynamics SL 7.0 FP1 being installed in the WOW folder)
Database Server Requirements:
Windows Server 2008 Standard and Enterprise Edition (32-bit
and 64-bit)
Client Workstations Requirements:
Windows Server 2008 Standard and Enterprise Edition (32-bit
and 64-bit) (Note: 64-bit option supports Dynamics SL 7.0 FP1 being installed in
the WOW folder)
Note:
For a full listing of requirements, go to
Link to SL 7.0 System Requirements Guide
Q:
What are the SQL 2008 Requirements?
SQL Server 2005 SP2 Standard or Enterprise Edition (32-bit and
64-bit)
SQL Server 2008 Standard or Enterprise Edition (32-bit and
64-bit)
Note: For a full listing of requirements, go to Link to SL 7.0 System Requirements Guide
A:
For SQL Server 2000
(KB 936578)
To use
SQL Profiler in
SQL Server 2000 to
trace database events in Microsoft
Dynamics SL or in
Microsoft Business
Solutions - Solomon, use the appropriate method:
|
• |
Use Method 1 if you want to
trace the database events that
are generated by all the Microsoft Dynamics
SL client computers or by all the
Microsoft Business Solutions - Solomon client computers. |
|
• |
Use Method 2 if you want to
trace the database events that
are generated by a specific Microsoft Dynamics
SL client computer or by a
specific Microsoft Business Solutions - Solomon client computer. |
|
• |
Use Method 3 if the computer that is running
SQL Server hosts multiple
databases, and you want to limit the
trace to the database events in a specific Microsoft Dynamics
SL database or in a specific
Microsoft Business Solutions - Solomon database. |
Note
You can view the
trace results on the monitor. Or, you can
save the trace results to a file. If you
save the trace results to a file, you can
send the file to technical support for review.
Method 1
|
1. |
Download the KB936578_SQL2000.tdf file to the desktop
of the computer that is running SQL
Server 2000. The following file is available for download from the
Microsoft Dynamics File Exchange Server: Release Date: May 18, 2007 |
|
2. |
Click Start, point to All Programs, point to
Microsoft SQL Server, and then
click Profiler. |
|
3. |
On the File menu, point to New, and then click
Trace. |
|
4. |
Connect to the server that hosts the Microsoft
Dynamics SL databases or the
Microsoft Business Solutions - Solomon databases. |
|
5. |
In the Use the follow
trace template section, click the folder button next to the
Template file name box. |
|
6. |
In the Look in box, click Desktop, click
KB936578_SQL2000.tdf, click Open, and then click
Run. |
|
7. |
Click File, and then click Pause
Trace. |
|
8. |
Start Microsoft Dynamics
SL or Microsoft Business
Solutions - Solomon, and then run
the program to the point before the event that you want to
trace.
|
|
9. |
Switch to SQL
Profiler, and then click Run. |
|
10. |
Run
Microsoft Dynamics SL or
Microsoft Business Solutions - Solomon until you complete the event that
you want to trace. |
|
11. |
Switch to SQL
Profiler, click File, and then click Stop
Trace. |
Method 2
|
1. |
Download the KB936578_SQL2000.tdf file to the desktop
of the computer that is running SQL
Server 2000. The following file is available for download from the
Microsoft Dynamics File Exchange Server: Release Date: May 18, 2007 |
|
2. |
Click Start, point to All Programs, point to
Microsoft SQL Server, and then
click Profiler. |
|
3. |
On the File menu, point to New, and then click
Trace. |
|
4. |
Connect to the server that hosts the Microsoft
Dynamics SL databases or the
Microsoft Business Solutions - Solomon databases. |
|
5. |
In the Use the follow
trace template section, click the folder button next to the
Template file name box. |
|
6. |
In the Look in box, click Desktop, click
KB936578_SQL2000.tdf, and then click Open. |
|
7. |
On the Filters tab, expand HostName in the
Trace event criteria box. |
|
8. |
Expand Like, type the name of the appropriate
Microsoft Dynamics SL client
computer or of the appropriate Microsoft Business Solutions - Solomon
client computer, and then click Run. |
|
9. |
Click File, and then click Pause
Trace. |
|
10. |
Start Microsoft Dynamics
SL or Microsoft Business
Solutions - Solomon on the client computer.
Run the program to the point
before the event that you want to trace.
|
|
11. |
Switch to SQL
Profiler, and then click Run. |
|
12. |
Run
Microsoft Dynamics SL or
Microsoft Business Solutions - Solomon until you complete the event that
you want to trace. |
|
13. |
Switch to SQL
Profiler, click File, and then click Stop
Trace. |
Method 3
|
1. |
Determine the DBID of the database in which you want
to trace the events. To do this,
follow these steps:
|
||||||||
|
2. |
Download the KB936578_SQL2000.tdf file to the desktop
of the computer that is running SQL
Server 2000. The following file is available for download from the
Microsoft Dynamics File Exchange Server: Release Date: May 18, 2007 |
||||||||
|
3. |
Click Start, point to All Programs, point to
Microsoft SQL Server, and then
click Profiler. |
||||||||
|
4. |
On the File menu, point to New, and then click
Trace. |
||||||||
|
5. |
Connect to the server that hosts the Microsoft
Dynamics SL databases or the
Microsoft Business Solutions - Solomon databases. |
||||||||
|
6. |
In the Use the follow
trace template section, click the folder icon next to the
Template file name box. |
||||||||
|
7. |
In the Look in box, click Desktop, click
KB936578_SQL2000.tdf, and then click Open. |
||||||||
|
8. |
On the Filters tab, expand DBID in the
Trace event criteria box. |
||||||||
|
9. |
Expand Equals, type the DBID value that you noted in
step 1d, and then click Run.
|
||||||||
|
10. |
Click File, and then click Pause
Trace. |
||||||||
|
11. |
Start Microsoft Dynamics
SL or Microsoft Business
Solutions - Solomon, and then log on to the appropriate database.
Run the program to the point
before the event that you want to trace. |
||||||||
|
12. |
Switch to SQL
Profiler, and then click Run. |
||||||||
|
13. |
Run
Microsoft Dynamics SL or
Microsoft Business Solutions - Solomon until you complete the event that
you want to trace. |
||||||||
|
14. |
Switch to SQL
Profiler, click File, and then click Stop
Trace. |
For SQL Server 2005
(KB 925033)
To use SQL Profiler in
SQL Server 2005 to
trace database events in Microsoft
Dynamics SL, follow these steps:
|
1. |
Download, and then save the SQL2005.tdf file on the
desktop of the computer that is running
SQL Server 2005. Release Date: May 3, 2007 |
|
2. |
Double-click the KB925033_SQL2005.tdf file, and then
click OK when you receive the following message:
SQL
Server Profiler - File C:\Documents and
Setting\username\Desktop\DynamicsSL2005.tdf was imported successfully |
|
3. |
On the File menu, click New
Trace. |
|
4. |
Connect to the server that is hosting the Microsoft
Dynamics SL databases. |
|
5. |
On the General tab, click the Use the template:
drop-down box, click to select KB925033_SQL2005 (user), and then click
Run. |
|
6. |
Click File, and then click Pause
Trace. |
|
7. |
Start Microsoft Dynamics
SL.
Run Microsoft Dynamics
SL to the point before the event
that you want to trace.
|
|
8. |
Switch to SQL
Profiler, click File, and then click Run
Trace.
|
|
9. |
Run
Microsoft Dynamics SL until you
complete the event that you want to
trace. |
|
10. |
Switch to SQL
Profiler, click File, and then click Stop
Trace. |
Note
The
trace results can be viewed on screen. The
trace results can also be saved to a
file. The file can then be sent to technical support for review.
This concludes the issues and questions tracked during the
Existing Customer Roadshow Events from SL participants.
We thank you for your participation and encourage you to submit and vote
for enhancements that will make your job easier!