Hey Wes, write us a review.

Steve Jones

steve@dkranch.net

I had a similar problem. I rebooted the server, then stopped the SQL services and was able to get the script to run.

Steve Jones

steve@dkranch.net

Usually when you connect through a COM object, the object proxies the user account. In other words, the user account is not used to connect to SQL Server, the account...

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...