Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kaiser18au

  1. kaiser18au

    Can bcp do binary data with -c

    Hi all, I was wondering if anyone can tell me this. I am using BCP to do my data transfer from SQL65 to SQL7. The statement is like: bcp TableName out “outfile.txt -e "C:\Temp\bcp\sql_err.txt" -b 10 -n -6 -q -S "ServerName&quot...
  2. kaiser18au

    does bcp do binary data?

    Hi all, I have set up a bcp process. This is bcping between a SQL65 to SQL7. I noticed that the database has a few image field and binary field. Does bcp copy over binary data also? I used the following bcp filename out -c -6 .... the -c is to say I will be using char type to transfer...
  3. kaiser18au

    DBO owner question

    Hi everyone, Just a quick question. I am trying to do a DTS to pull data across the network from a database on one server to another. The database has many tables. There are 3 owners to the tables. Owner1 owns 1/3 of the tables and Owner2 owns 1/3 and Owner3 owns 1/3. Some table names are the...
  4. kaiser18au

    help with remove replication from sql65

    Hello everyone, Could someone tell me what I have to do to remove fully replication from my SQL65. I have removed it using the "remove replication" menu option. But when i re-enter the program, it still has the distributor properties and subscriber database. It also complains, when...
  5. kaiser18au

    Replicate SQL65 to SQL7

    Hi everyone, Can anyone tell me if they have had any success on replicating SQL Server. I have ServerA with SQL65 and ServerB with SQL7. ServerA is set up as a publisher and ServerB as the Subscriber. I have had alot of problems with this setup. I cant set it up, though I am able to set up...
See more

Part and Inventory Search

Back
Top