Can I use a wildcard with BCP to import all the text files into the table?

Yes, I was wanting to place dbl quotes around my text in the output of BCP.

I have 45 tables I need to export to text. I looked at using DTS...

Steve,

I feel your pain. it is a peice of (*&^!!!!!

It has been nothing but problems. What makes it worse is different department manages the backup/restore process.

Went from Informix ODBC CLI 2.1 to Informix 3.31

I agree on the upgrade the client tools. What are some of the impacts of using SQL200 client utilities to adminster SQL 7 servers. Especially in the DTS realm?? -JG

...

RESOLUTION:

I upgraded the MDAC to 2.5 SP2. Althought this did not correct the problem I started to get a different error. I upgraded the Informix ODBC driver and that did...

Yes I hightlight the line then perform the shortcut.

Steve,

My understanding of ISNULL; The value you want returned must be of the same datatype you are wanting to swap out the null with.

example. If the NULL Column is...

Steve,

Does the ctrl-shift-C work with 7.0 QA? I tried it but it did not comment the text. -JG

While working as a Lead Systems Engineer, I worked closely with the DBA's. I was very curious to what they did and slowly worked more and more with Databases. I...

See if this helps:

Select dateadd(ss, 91423, 0) -JG

Might of miscommunicated on the last entry. I was trying to communicate that it is necessary to update the stats after rebuilding the index.

richcoulson if you look in Books online...

Brian has a nice script that disables constraints it you want to look it over. It is on this site. here is the exact URL.

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=25

I found out the issue.

Microsoft Bug #236652

FIX: SQL Mail 2000 Needs Microsoft Outlook 2000 Client (Q281293)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281293

Is there any difference in configuration of the excahnge client/outlook for 2000k that is different thant the configuration for SQL 7?