Use just like a regular table in SQL2K...

select * from OpenQuery(AS400, 'select * from "F.M.AS400Table" ') AnAS400TableAlias

Insert into OpenQuery(AS400, 'select fld1 from "F.M.AS400Table" ') AnAS400TableAlias

Select QSL2kFld1 From SQLTable

Notice AS400 query was...

Win2k - (RightClick) My Computer - Properties - Advanced - Performance Options

Not specific to your "error"....

We create a linked server on an ODBC entry using Client Access.

CA version must match AS400 O/S etc...

OLEDB not so kind as the ODBC ???

Just thoughts,...

Thanks Frank....

MS Site has - "

Don't they know how big it is?

I used to write "Here's a shameless plug..." got tired of doing that.

As far a Date Formating, I submitted into the scripts section of this site, VB-like SQL UDF.

Check out @ http://www.sqlservercentral.com/scripts/contributions/1007.asp

If you look at query plan for a query with an "IN" clause with 2 or more values, you'll see an "OR" happening, so perfomance wise, IN & OR may be...

Get / rent a wireless / CDPD laptop setup. Tell them you're taking notes.

And sit in the back.

I just want to know what I have to do 800 years from now when I'm dealing with my "current date" code.

Signed L....

Giro,

The reason is, the O/S will recreate the pagefile when it is restarted, or dynamically size according to needs. Many, many O/S operations use this file, not only for...

Good questions can contribute just as much, or even more than good answers, and always are better than bad answers.

Funny, I was just on anther thread about linked servers... I do not want to make a "permanent" linked server, for various reasons... but maybe the "failer" of being able...

BOL - SysServer - IsRemote = "1 if server is a remote server, else 0 if server is a linked server."

hmmmm

I added a Linked...

Try...

  SELECT SRVName, IsRemote, * FROM Master.dbo.sysServers

to get started.

BOL about SysServers table has notes on IsRemote column I do not think are quite right...

Looking deeper... will post more

I agree, but I think having it fixed sized is of greatest performance importance.

I like to "fix size" as early in the PC installation process as possible so that the

permanent,...