IS this Std or Ent SQL Server? Standard can only use 2GB.

I might also specify an amount for sQL Server rather than the dynamic memory management. Is this a...

Doh!, typo.

It is fixed. Glad I didn't have syntax error as a choice

Yikes, I'm confused. It is recommended, as are many things, but it's not required, i.e. needed. How is this that badly worded?

Rode as a kid a little. My kids asking for one. We'll see.

Are these user tables? Maybe reserved words for the column names?

That's what I was going to suggest!!!

update mytable

set col = substring( cast(newid()as varchar(80)), 1, 8)

It has to be some sort of security setting for the activeX stuff that the forums load.

George, you are right on about the craftsman. Too many people are no longer willing to work to be one.

DBMS ?=? ORDMS ?=? ODMS

Thanks Carlos, I thought it was great as well.

Apparently not many others have time for a 9 page interview , maybe they'll read it...

There is data in the system tables that marked things are replicated. That's why they appear in SSMS. You can manually reset things in the system tables, but you'd need...

Note that it is running on the server, not your machine. So the path from the server, with the SQLAgent login logged in is what must be checked.

JT, maybe you want to write my editorial one day

I started with DBase/Clipper, no DRI there. You can to manually open each...

I agree, this is not recommended. I'd rather have you use VBScript to read some Outlook mailbox on another machine and then do an insert into SQL Server.