Hi, can anybody help me on this issue? thanks.

Hi,

There is no sql server authentication available for me to connect to SSIS

That means I am not able to remotely connect to the SSIS through Management Studio.

If so, does...

Hi,

You mean SSIS account or sql server?

SSIS-Network Service

SQL -Local System

What can we do on SSIS if we still need to retain Local System as a startup account for SQL...

Hi,

You mean SSIS account or sql server?

SSIS-Network Server

SQL -Local System

What can we do on SSIS if we still need to retain Local System as a startup account for SQL...

Hi all,

Thanks for the information provided.

Thanks all.

How can I ensure the index is being used by the query?

Through execution plan?

Index creation is a workaround, is there any advice to have both performance improvement but with less db size increment?

By the way, is it necessary for me to create clustered...

Hi all,

Thanks for the explanation above.

Really appreciate it.

Regards,

Golden

Hi Adi,

Thanks for the information.

I thought it clear my doubts.

Hi,

I think maybe you can create a schedule jobs to execute the T-SQL statements in different steps of a scheduled jobs.

You can control the order of the steps by...

ChiragNS (10/13/2009)

sp_change_users maps a login to a user. By itself it will not generate user permissions. Have u transferred the users from your SQL 2000 db to SQL 2005...

Hi sql_lock;

Sincerely apologize for the late reply.

I have tried BIDS transferring job task and it is successfully, will those jobs work properly in sql server 2005 although they are still...

I use the method that is provided by miscrosoft website.

http://support.microsoft.com/kb/246133/

It seemed to generate the login and default DB, however it seemed not to generate the object permission.

Is there any other methods aside from using BIDS?

Do you have any opinion about the object permission ?

Hi Chris,

Thanks a lot, it works

I really appreciate your help and advice.

Regards,

Golden