Sean Burke wrote an article addressing some things. You can read it here:

http://www.sqlservercentral.com/columnists/sburke/introductiontostoredprocedures.asp

Steve Jones

steve@dkranch.net

When you do the 3 tier, the MTS login must have an account on SQL Server. Have you checked this?

Steve Jones

steve@dkranch.net

Use a tinyint, no nulls.

If you allow nulls, then you have a 3 values field, not 2.

tinyint is the best choice for the reasons outlined by mdburr above.

Steve Jones

steve@dkranch.net

SMTP is Internet email.

BCP is a utility that ships with SQL Server. It can be distributed to your partner and can run on any windows workstation. The workstation will need...

Are the Paradox and FoxPro files on the local server or a remote location?

I see this occasionally. It appears that once the xfer starts, it is very intolerant of network...

You could setup a table, give a login/user rights to just this table and let the other company BCP in.

If you do, I'd recommend setting up a field that has...

The only way would be to have a trigger "send" a message to the app. This may involve a COM type object, but I would recommend against it. If the...

Lots of debate on this one. Some people think that the data itself should generate the primary key.

I like to use identities, but they are problematic when moving data from...

I ran this:

create table Logins

(

LoginID varchar(8),

[Password] varchar (8)

)

go

insert logins select 'Bill', 'Gates'

insert logins select 'Tick', 'Tick123'

go

select * from logins

go

select * from logins where loginid='Bill' and [Password]=ENCRYPT('GATES')

go

drop table Logins

No rows returned...

Noel,

Outstanding!!!! I didn't know this.

Thanks for the info.

Are you interested in writing a short "Transferring System Tables" article? If not I will, but it's a great topic.

Steve Jones

steve@dkranch.net

I am strictly MS for DB servers (5 SQL2K, 1 SQL7).

I do, however, work on the network architecture and management for our firewall and load balancer.

Steve Jones

steve@dkranch.net

My 2 cents:

Use Log shipping. Both methods will do the job, but when you have a failure and have to move back to the primary, replication will be more problematic.

Log...

It's hard to pick benchmarks, because what works for one app may not be good for another. Trans/sec is only a good benchmark under a steady load. If your servers...

You can link tables in Access to the same tables in SQL.

Steve Jones

steve@dkranch.net

You will likely have to call MS for support. Have any changes, anything at all, even not SQL related been made to this server? When was the SP applied?

Steve Jones