Calling Dex Procedures from SQL
Is there any way to call dex procs from SQL or VB code?
There is an undocumented and unsupported method of calling Dex code from
VBA. However, I know of no method of calling Dexterity from SQL.
Please email me if you want an example, just remove the online. from the
David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This p...is SQL 2000 architecture different SQL Server 2005 / 2008 architecture?
Hi I have a book "inside SQL Server 2000" by Kalen Delaney, which I
have been told is a good book. I am going backwards... reading about
the sql server architecture in chapter 3 of the book.
As I'm reading... I was wondering is it different SQL Server 2000 vs
SQL Server 2005/2008? Also
where can I find a book/or link that can give me more details about
the internals on architecture?
norm (email@example.com) writes:
> Hi I have a book "inside SQL Server 2000" by Kalen Delaney, which I
> have been told is a good book. I am g...Moving Data From One Form To Another
Hi all, I have a form that shows student information (primary key =
student ID). I have buttons on this form to bring up other forms that
can be used to register student for certain events. The first form is
data from a student table, while the ones for registering the student
are connected to a table s called Students Registered for an event
(primary key = Student ID + Event ID).
The problem is, then when you open the registration form, you have to
manually put in the Student ID as input. I would like to pull whatever
Student ID was currently showing in the Student form to be
automatically p...Moving customizations from SQL 2k to SQL 2k5 CRM
This may be a non-issue but I wanted to check to see if anyone has done this
and ran into issues.
I have the XML customization files from our previous install of CRM 3.0 with
SQL 2k database. I now want to import and publish these same customizations
to CRM 3.0 on SQL 2k5.
Has anyone done this or can point me to documentation that tells about the
success or issues for doing this?
On 7 Feb., 06:35, Chris Treanor
> This may be a non-issue but I wanted to check to see if anyone has done this
> and ran into issues.
&...IM ODBC MS Access 'read permissions' error
I am stumped. This is the first time I'm using IM with Access as the
source; I never have any trouble with other sources but can't get this
I'm trying to set up IM using Access DB query as the source. I seem
to be able to make the connection with the DB no problem as I can
select from the list of tables from the datasource, however, IM is
"unable to obtain column info..." with the following error returned by
ODBC "[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be
read; no read permission on 'qry...'."
The login/pw I used in the ...Cannot install the 3rd Exchange 2003 Server
Please help me. I cannot install the 3rd exchange Server 2003 on windows
server 2003 Std with SP1 and without SP1. My AD is Server 2003 with SP1. The
other 2 Exchange Server is 2003 std with SP2.
During installing a new Exchange computer into the organization, I receive
the following error message:
Setup failed while installing sub-component Site Replication Service with
error code 0xC007054B (please consult the installation logs for a detailed
description). You may cancel the installation or try the failed step again.
And the log is have the following error:
[19:50:13] DS or RPC is b...Elimate year (either YY or YYYY) in data
I want to format a column ONLY using day and month so that I can sort
by that column. The default includes the year I have entered the data
(i.e. 2004 or 2005) which corrupts the sort. Anyway to remove it? I
have tried custom and special under format. Doesn't work. Thanks.
Why doesn't MMM DD, MMMM DD or M/DD work in custom formatting?
"Jack" <firstname.lastname@example.org> wrote in message
I want to format a column ONLY using day and month so that I can sort
by that column. The default includes the y...Free & Busy Data messed up.. Plz Help!!
We have exchange v5.5. Recently one of the exchange
admins was in the public folders messing around with
permissions. He said he didn't change anything but
something had to have changed because now all free and
busy data, public address book, tasks, notes, etc are not
accessible to new users. Any time we create a new email
account they can't view there calendar (says it doesn't
exist), nothing shows up in the global address list.
Anytime they receive an email to accept a meeting it says
unable to open item. I've done the usual things like
reset the server. I loo...Need to add check transactions to Microsoft Money using OFX file (not bank statements)
Does anybody have an example of an OFX file that imports check transactions
into Microsoft Money? I need to simulate the manual input of checks. Dut
to problems in our accounting software, it's best to enter transactions in
our accounting system and rekey them into MS-Money.
I found some "statement" files but I am thinking this isn't what I need to
I appreciate the depth and functionality of ofx vs. qif but I am finding it
difficult to find ofx examples since they all appear to be produced by large
companies (i.e. banks and financial companies)
Any help wo...CRM 3.0 Install Error with SQL Reporting Services and SQL 2005
Doing a CRM 3.0 Server installation. During the last page of the install
wizard (or what I assume is the last page) when I goes through and does
verification I get a red X next to SQL Reporting Services. The message I
receive when I look at the details is:
The specified path is not a metabase path.
Parameter name: path
Now SRS is installed and working. I put in the URL:
http://<servername>/reportserver and every other variation on that I can
also assuming you did not use ssl...
=======================...Comparing two sets of data, and outputting the matches to another location
Hello. I have a problem I've been working on for a few days now, and
I can't seem to come up with a solution.
I have two columns of data. The first is a list of company employees
sorted by last name (about 10,000 names), followed by the department
they work in. The second is a sample list of the employees (about 200
names), also sorted by last name, and the computer systems access
level they have. What I want to do is compare the second list to the
first list, and where the names appear on both lists, output the data
from both columns (for that name) to a third location. The goal...Capturing data
I am working on a registration form for a meeting. I currently have a sheet
set up as a registration form with cells for various fees to be paid by the
registrant. My current plan is to use a seperate sheet for each registrant
(approx 100 - 150) all within the same workbook.
The question is: What would be the best way to summarize the various
amounts paid and the numbers of people registered for each event all onto
one sheet? I looked at using a Pivot Table, but apparently my data on the
registration form is not arranged correctly. I have been looking at using a
summary sheet with...SQL 'for xml' and C# example??
I'm missing some piece of the puzzle. I'm using 'for xml' type queries from
SQL2K - and now trying to change the front-end from ADO to C#, I can't quite
figure it out..
It seems that I could use an XmlReader.. and somehow use that instead of a
DataReader.. but that didn't work.. I tried using a DataReader and get the
byte array - but that wasn't right.
SQL returns formatted XML, I need to load that XML into an XmlDocument
somehow without ANY molestation of that dom. Any ideas? Examples? Missing
THANKS!! I've been looking for the answer to ...Import data to pivottable
Is it possible to create a pivot with reference to several data from diffent
sheets in the same excel file. I am trying to manage data on money
transactions. These transactions are different in their nature (grouped into
the different types) and I would prefer if they were in seperate sheets.
In these sheets I want to manage transaction from an account to an other
account, therefore I got 2 colloms with the name "account name". This curses
some problems because I want the "Row" of the pivottable to be "Account
name". I want the pivottab...sql summarizing help
id, cdate, weeksago, amount, typeid, timeclose
496, 2010-02-11, 0, 450, 3, 1
490, 2010-02-01, 1, 200, 4, 1
491, 2010-02-01, 1, 350, 2, 2
493, 2010-02-01, 1, 500, 5, 1
489, 2010-01-21, 3, 150, 2, 1
136, 2010-01-12, 4, 500, 3, 2
137, 2010-01-12, 4, 100, 3, 1
138, 2010-01-12, 4, 500, 2, 1
1. i'm trying to create a sql that will give me a summary resultset grouped
2. i want to sum the columns and get counts based on typeid.
3. avg of timeclose
here's the sql i have:
, (sum(timeClose)/(count(timeclo...Project Server Cube Build Issue
I think I screwed up the install order on the SQL DMO components. According
" At this time, do not use the feature packs for SQL Server 2008 to install
and download these components, as those files will not allow you to build
cubes in SQL Server 2008 Analysis Services with Project Server 2007."
However, I didn't read that carefully enough and installed the Microsoft SQL
Server 2008 Management Objects Collection instead of the 2005 version. Now I
can't install the 2005 version even if I uninstall the 2008 version. The
setup fails with the "highe...using Forms and VBA within Excel
I need to develop an application with Excel which will include Forms and VBA
I have done small projects like this before but this will be significantly
larger with 6-10 forms and navigation (via command buttons) between the forms.
I have heard rumors that forms within Excel can be troublesome (e.g. they
can disappear without warning). I have never had problems with this before.
But still wanted to ask the community - are there know issues with using
Forms and VBA within Excel. The main functionality of the app will be to
validate and capture data, store the data in Excel a...Update multivalue field in table from form with SQL
Access 2007 on Vista
I am using a form to establish the variables for a report before it is
created. One field on the underlying table is a multivalue field, and the
form includes a multi-select combo box control. After selections are made and
the OK button on the multi-select combo drop down is clicked, focus moves to
the next control. I have discovered though, that the underlying table does
not update immediately, but does so correctly when I close the form. This
sequence does not deliver the proper report data, so I need a way to
immediately update the underlying table (m...Refer to SQL statements globally
I have two large SQL statements that I need to use across several
forms, reports, etc.
Rather than repeat them in each form, I'm trying to store and
reference them globally.
For example, I'd like to store strSQL1 and strSQL2 in a global module,
so I can use either like this in a form:
Me!lstResults.RowSource = strSQL1
Me.Report.RecordSource = strSQL2
Would I just store the SQL statements in a global module like:
Public Function SQLSource() As String
Dim strSQL1 As String
Dim strSQL2 As String
strSQL1 = "SELECT blah blah...Uninstall CRM, but retain data?
I'm having so many problems with CRM (too many crazy asp.net errors) that
instead of spending all my time troubleshooting, I'd like to uninstall and
reinstall. However, I have data in my CRM. Not a huge amount of data, but I
have 4 userss in there with say, 100 contacts and other information in there
each. I know all that info resides in the SQL DB too.
Is there a way, that if I uninstall CRM, can I preserve that data and
possibly import it back in once I get a new CRM running? Never created any
custom anything. Our CRM was pretty much default all the way. I'd hate to ...To SQL or not to SQL?
I have a very vertical product developed 100% in M/S Access. I developed it
myself in 1993 in the initial release of Access and been with it ever since.
It is currently very stable and running in Access 2003. My big question is
how or even *if* we should move it to SQL. My customers are getting bigger
all the time with more users. Typically our customers run one or two
workstations generally never more than 5. Performance, however, is starting
to slow with database sizes passing 500 meg. We also have a LOT of code
behind forms so are bound tightly to the Access development environ...writeback to SQL 2005
hello! I use excel 2007
iI open a connection agianst SQL server 2005 and choose a table. In my
workbook i can now see this data from this table. if i change a value in some
cell i wish to writeback to table in SQL server. Is this possible?
It's possible through the use of VBA and ADO, but not simply using the data
connection you've already established.
"CJ" <CJ@discussions.microsoft.com> wrote in message
> hello! I use excel 2007
> iI open a connection agianst SQL server 2005 and choose a table...Server
Working in a large office we have recently replaced our
The new server has a different name fom the old one.
For the vast majority of users this has not caused a
One user about once a week cannot open hois Outlook and
the server name reverts back to the old server name.
Please help !
...creating a program that uses data from a sensor....
I want to create an MFC program that uses parameter values passed to it
from a meter (specifically the resistance in ohms of resisters in an
electronic circuit). What are the hardware components that would be
needed? And what MFC class(es) would I use to accomplish this?
On 21 Oct 2006 08:10:50 -0700, "RAB" <email@example.com> wrote:
>I want to create an MFC program that uses parameter values passed to it
>from a meter (specifically the resistance in ohms of resisters in an
>electronic circuit). What are the ha...CRM Data Dictionary
Wouldnt it be very helpful if we had the CRM Data Dictionary?
I am just starting developing reports with CRM 3.0, and I am coming
accross some views,
I would like to know more about them, of course, I am already having a
look at the database, but if someone, somewhere, had already done
that, I would be so grateful if he or she could drop me some hints, or
even a data dictionary document.
thanks in advance,
The CRM schema is quite well documented.
Start with ER diag...