Hello,

for everybody:

Using a Join Trnsformation to make what I need

thank

thank to everybody,

bcp is used to export data, so to run bcp in TSQL I have to enable XP_cmdshell.

SSIS in this project is not used.

If anyone find another way let...

I have used sp_executesql, as written at the beginning (first message).

Anyway later I'll give you a piece of code.

Hello,

if you change

set @sql = 'select * from t1'

with a statement like:

set @sql = 'INSERT....' and you have a duplicate key,

the error is not catched, I mean the code...

Thank everybody,

the problem is:

for example 1 I do not catch the error : it is a INSERT statement that produce an error because of duplicate key row.

for example 2, it is...

Hello,

using @@error is not possible to catch the error. 

Any help will be very appreciated

Thank

Hello,

using if @@error <> 0 I do not catch any error.

Please,

anyone can help me?

Thank

Hello,

AWE enabled is only to take advantage of more than 4GB (switch /PAE maust be enabled in boot.ini).

/3GB (for server with less than 16GB) to have more memory (in this...

Hello,

thank for replying. Any further help will be very appreciated

Thank,

but the problem is that the size of corralated table increase (T1, T2, T3 and so on are corraleted), so I need to partition them.

but I want to maintain a...

Hello,

thank for reply.

I know what is partitioning table, so I want to use this new feature to divided data into "partitions" when table increase too much, this is very helpful...

Hello,

I make an example: T1, T2 and T3 are tables:

and they have the following cols:

T1(t1_pk (int), col2 (varchar), col3 (varchar), col4 (varchar), createtime (datetime))

T2(t2_pk(int),t1_pk(int), col5 (varchar))

T3(t3_pk(int),t2_pk(int), col6 (varchar)).

My question is:

Can I...

Useful tool for everybody:

http://www.microsoft.com/sql/solutions/migration/access/default.mspx

from Access forum

I run the tool and MS access DB was converted to SQL server DB.

Thank