SQLgetinfo

[Robert]

I am new to Access/SQL server. I need to determine for performance which
aggregate functions are not supported by SQL Server. I understand one way
is to query the server to see if the function has to run locally or it can
run remote. How can I poll the server?

[Guinness Mann]

In article <HM********@news.boeing.com>, st*******@whitehouse.gov
says...

I am new to Access/SQL server. I need to determine for performance which
aggregate functions are not supported by SQL Server. I understand one way
is to query the server to see if the function has to run locally or it can
run remote. How can I poll the server?

Access is like a car. SQL Server is like an airplane. Cars can go on
the ground. Airplanes can fly.

Does that help?

[Robert]

Yes, major help. Thanx!

"Guinness Mann" <GM***@dublin.com> wrote in message
news:MP************************@news.newsguy.com.. .

In article <HM********@news.boeing.com>, st*******@whitehouse.gov
says...

I am new to Access/SQL server. I need to determine for performance which aggregate functions are not supported by SQL Server. I understand one way is to query the server to see if the function has to run locally or it can run remote. How can I poll the server?

Access is like a car. SQL Server is like an airplane. Cars can go on
the ground. Airplanes can fly.

Does that help?

[Guinness Mann]

In article <HM********@news.boeing.com>, st*******@whitehouse.gov
says...

Yes, major help. Thanx!

Seriously, there is not a great deal of intersection between the two
products, other than that they are made by Microsoft and there are some
utilities to help you upgrade from Access to SQL Server.

In SQL Server, *all* queries run remotely. In Access (well, the jet
database engine, which is what you will be communicating with), *all*
queries run locally. I found that out the hard way when I created a 300
MB mdb (Access) database at a site in Wales and then went back to my
office in San Diego and tried to run queries against it over a 64k ISDN
line. For each query the entire 300 MB database had to be transferred
from Wales to California, one record at a time. Had I used SQL Server,
only the results would have had to be transferred.

It sounds like you need to do a little bit of reading. Erland will be
along in a little while to give you a URL where you can download the
help files for SQL Server (known around here as the "bol"). Read some
of the introductory material in there and then come back with some more
specific questions.

--
Who's better for furniture? NOOOOOOOOOOOOOOOOOOBODY!!!!
--

Guinness Mann
GM***@Dublin.com