Search results for query: *

My table contains a field (m_akt) which discribes the day when to start a DTS-Paket. This works fine when to start once a month. I would like to insert 1,15,25 in this field to start the paket on the first, the fifteens and the twentyfifth a month. But this does not work. Here is my query...

Is there any way to export data from a table to a text file including column names ? This is my first attempt: exec master..xp_cmdshell 'bcp "select * from table" queryout c:\test.txt -c -t; '

I'd like to import various text-files with various numbers of columns to existing tables. The problem seems to be that the the text-file for example contains 250 columns while the table contains 260 columns. The source columns should be copied to the first columns of the destination table...

Sorry it does not work. There must by something wrong with the select statement. Any ideas ? ULi

Hi, do anyone find the fault ? ------------------------------ SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO ALTER PROCEDURE [Fallauskunft] (@nr int) AS begin declare @alles varchar(8000) select @alles =' select * from openquery (connection, ''select * from...

I'd like to select 10 rows with a simple query. The source table contains 1,9 Mio rows. When I execute the query over the connection-server the result takes about 2 Minutes. Compared to the result over odbc (< 2 Sec) the performance is not the best. Is there any possibility to tune the...

Yes, thank you, it seems to work. But there's another problem. The performance is not the best, beacause of 1.9 Mio Rows per table. I tried with a stored procedure, but it's not even better ! Any ideas ? Uli

View: create view test as select l4_kopf.* from infonet.view_da2.view_da2.l4_kopf Error message: Server: Nachr.-Nr. 7399, Schweregrad 16, Status 1, Prozedur test, Zeile 3 Der OLE DB-Provider 'MSDASQL' meldete einen Fehler. Der Provider unterstützt die erforderliche Methode nicht. [OLE/DB...

Simple view: create view as select * from connectionserver.database.schema.table SQL-Server message: ODBC-Fehler: Die Operation konnte nicht ausgeführt werden, da der OLE DB-Provider MSDASQL keine verteilte Transaktion beginnen konnte ODBC-Error: OLE-DB Provider could not handle shared...

Hi, I'd like to set up a Connection-Server with SQL_Server 2000. Therefore I used the Enterprise Manager to connect via ODBC (tdata32.dll Version 2.8.2) over OLE (Security) to teradata. The connection seems to work fine. I see all views and tables on the teradata database. But when i tried to...