Both prior (now 3) of my post attempts since the "Banner turned off temporarily"

let me edit message body on 1st try

Sorry about overlooking the "system" database thing ...

I just posted the way I use to access & update "basic" Access databases & tables.

I wrote a function that expands to 64 bits (8x8) that might be usefull...

Create Function fn_BigIntToBinary (@bi BigInt) 

RETURNS Varchar(72)

AS

Begin

/*

-- Returns 64 bits of...

I love bits... when you understand the bits, then all else falls into place.

Also makes me think back to the good ol' M/L days on the 6502, 8088, Z80

You can set and get the info in SQL's Server Network Utility.

Some SQL installs it's in the Start-Programs-SQL Server section,

otherwise its "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe".

Look at TCP/IP Properties on General tab.

There...

First, just simply try

exec master..xp_cmdshell 'dir p:\'

in Q/A with you logged into Q/A under the security context that the mapping to P: allows.

In other words, if the Unix box allowed...

Try

select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Accessdb.MDB';'admin';'',

  'select * from AccessTable')

from within T-SQL

Don't give up yet...

Can you post your SELECT that gives yo your original result set?

Let's say you original SELECT was

SELECT id, desc, SUM(Total) as [count], SUM(GTotal) as flag

FROM MyTable

GROUP BY id, desc, flag

then you can use the original query as a derived table as...

Thanks, FYI, I get the email reply notifications, just not subscribed forum posts.

If ALL your text data is less than 8000 bytes per record, then you could

select replace(Convert(VarChar(8000), comments), '"', '"')

from tblcaseinfo

where PatIndex('%&quot;%', comments) <> 0

Notice PATINDEX for your search condition.

If it's longer,...

Seems about 1 out of 5-10 tries let's me type.

When I can not type, the Explorer status bar shows

1 out of 1 items remaining.... seems to hang forever.

When I...

Your statement is identicel to

select distinct code

from Table1

where code is not null

and code <> ''

and code in (select Table1.code from table2)

You...

Is there any error message in the "details" of the Job history?

Is there a chance the Foxpro data has been accessed within a minute prior to the Job run?

...

We have alot of different mobile applications communicating data to and from SQL Server.

Some of the apps use DBFs, SQLCE, and MSDE.

I do not use replication because of...