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

steve@dkranch.net

Use it on both.

export from v6.5 using it IF you are using the v2000 BCP program. You could also use the v6.5 program (on the v6.5 server) and then only...

What type of remote server? Different providers support different types of operations.

You should be able to add this item as a linked server and perform a delete against it. If...

You can get around the SQL 7 issue with a password, though you have to be aware of the differences in DTS tasks. Only some of the tasks are available...

yes they will.

Steve Jones

steve@dkranch.net

Rant does mean the same and nice rant.

I think you will find there will be a movement of the stuff you write in ADO to stuff MS has written. Don't...