Sounds like a test question for a class or an interview question to me.

Steve

Des Moines, Iowa

And with the weather like it's been this winter, it doesn't feel like heaven (Field of Dreams reference, "Is this heaven? No, it's Iowa.").

Steve

Just a quick side bar that may help someone, FTP normally does the translation from EBCDIC to ASCII. I'm not sure what needs to done on the Mainframe side...

The Data is coming from our production database where all the Constraints are in force. I've never had it fail for me. (I only do this once every few...

When I am reloading my test database (SS 2000), I run the following query first:

sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

go

sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"

go

(I disable the triggers...

I would think that the following will work as well

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Postcode = (Row.Postcode & "").TrimEnd

End Sub

Appending an...

I like to use Red Gates Sql-Compare to generate a script that will synchronize the test and production databases. I then use the script as a starting point for...

Maybe all you need is a replace for each character.

UPDATE #temp SET Phone = REPLACE(Phone, '(', '')

UPDATE #temp SET Phone = REPLACE(Phone, ')', '')

UPDATE #temp SET Phone = REPLACE(Phone, '-',...

I agree, look at the size of your backups in the BACKUP directory. Do you have a separate backup file for each time you backup? If so, do...

I'm not sure I've fully followed all the discussion, but I do have Logins from different domains coming into my SS 2000.

I have gotten the error mentioned with my...

I tried a google search on "independent software contractor book" and got the following:

http://www.goodreads.com/book/show/3076777.Working_for_Yourself_Law_Taxes_for_Independent_Contractors_Freelancers_Consultants

http://www.nolo.com/resource.cfm/catID/450464AB-FA7C-4AAC-B374F1BCE305E4DB/111/159/

http://www.poplarware.com/bizstart.html

I don't know if they are any good but it could keep you busy.

I always thought I...

I'm not sure about doing it within Dts, but if you create a Sql Server Agent job with 3 steps it works. The first step is disabling constraints, the...

When I load a test database using dts in ss 2000, I run the following first:

sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

go

sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"

go

After the dts...

Another thought that the original user might be interested in:

use Sql Server 2005 front end tools (SSMS, etc.) against a SS-2000 database.

I'm not fully sure of the value...

Agreed, Books Online is the way to go.

If you look under 'Contents' for SS 2000, Replication is one of the topics listed. Just expand it and jump in.

Steve