And there are a lot of information_schema views as well that will give you most of the information that you need about the meta-data. Search this site for information_schema...

In Query Analyzer, you will be able to view up-to 8191 characters i.e. after you modify that option from (Tools/Optoins/Results/Maximum characters per column). For data more than that, you...

There are couple of ways...one is:

declare @hr int, @min-2 int, @string varchar(20)

set @string = '10h 51m'

set @hr = charindex('h', @string)

set @min-2 = charindex('m', @string)

select substring(@string, 1,...

Depending upon your needs, you can also set up a linked server to the DB2 UDB database and pull data from there.  If you really want to push data from...

Yes, it is possible to do this in DTS...open up DTS designer and look at the transform data task, DDQ etc.

http://www.sqldts.com

will be a good site to start from.

You can map the network drive first and then use that mapped drive to do it.

You can trace it out via SQL Profiler to see what was passed back to the database.  That will cover the code that hits the DB.  For anything else, like...

In addition to what David has said above, please make sure that you have some join condition as well on the two tables -- right now, it is doing a...

You can either use the DTS export/import wizard and map the correct fields so that the autoincrement column takes place correctly or use bcp/bulk insert commands to do the loading...

It is possible but there is a round-about way of doing this.

If the proc. does not need any values:

1) Create a dummy table in Oracle.

2) Create an insert trigger on...

Rowid is not exposed in SQL Server.  You will have to use the primary key column(s) of the table.

You can use the bit data-type.  It can have values of 0, 1 or Null.

Using DTS directly to move the data over as well as linked servers will be slow.

1) You can create a DTS package that does this:

a) Runs bcp to bcp out...

For Primary Keys,

SELECT COLS.CONSTRAINT_NAME,COLS.COLUMN_NAME,COLS.ORDINAL_POSITION

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS COLS

INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS CONS ON

COLS.CONSTRAINT_NAME = CONS.CONSTRAINT_NAME

WHERE COLS.CONSTRAINT_CATALOG = DB_NAME()

AND COLS.TABLE_NAME = 'XXXX'

AND CONS.CONSTRAINT_TYPE = 'PRIMARY KEY'

ORDER BY COLS.CONSTRAINT_NAME, COLS.ORDINAL_POSITION

GO

For Foreign keys,...

You should use OLEDB provider rather than using ODBC (old technology now).  A connection string using the OLEDB provider will look like this:

Provider=SQLOLEDB.1;Password=pkmsqa;Persist Security Info=True;User ID=pkmsqa;Initial Catalog=MANH2004R20DATA;Data Source=ganesha

Initial Catalog is...