Did you leave out some code? I don't see anywhere that the first item produces a text file. How is it set to run?

2. Not sure. Can you post the...

Sounds like fun.

I always loved Fox.

Steve Jones

steve@dkranch.net

Some guidelines.

Use multi-CPUs from the go. Upgrading single to multi has never worked well from MS. Leave yourself room to grow, so buy a 4, 8, or bigger box and...

Gotta love those tools :).

Thanks for the update.

Steve Jones

steve@dkranch.net

You might try installing the SQL Tools on one workstation and seeing if that works. If so, I think the MDAC/ODBC drivers might be out of date, though they should...

I disagree especially for the sensitive access. Sooner or later that special person will change and having a role makes that more secure. If you use AD or integrated security,...

Adam,

Is the server NT? I don't think that there is a problem with the revisions being slightly off unless you are trying to make ADO calls (like MDX) that are...

Provides a little protection by introducing single user mode.

You could just use sp_renamedb.

Steve Jones

steve@dkranch.net

Creating the foreign merely requires that the parent key exist before the child can be inserted.

I can have:

Company

CompanyID Company

--------- -------

1 ...

Few things I noticed, still looking: sysxlogins uses a varbinary to store the sid. therefore there is no

real limit here.

In sp_addlogin, the sid is generated using NEWID(), which doesn't...

What versions and types of clients?

the other workstation may not be on the same domain.

Steve Jones

steve@dkranch.net

In Enterprise Manager, database properties.

Steve Jones

steve@dkranch.net

yes. it is a cisco (not sure of the model), but there is a Linux box behind it that functions as a firewall and provides the port mapping.

Sorry I can't...

Thanks, I thought I was missing something. I'll add that to my list of items like:

ID10T

PEBKAC

Steve Jones

steve@dkranch.net

Didn't know that.

Thanks Paul!!!

Steve Jones

steve@dkranch.net