Are you able to connect to SQL Server from a remote machine?

If so please check the memory consumption by the SQL Server as Adi Mentioned and try to limit the...

Install the 64-Bit Oracle client.

Thank You,

Best Regards,

SQLBuddy

What's the unexpected error ..? Please elaborate...

Thank You,

Best Regards,

SQLBuddy

10 GB...

1. Try to create an appropriate index so that the Report Stored Proc doesn't nun for 45 mins and thereby reducing the blocing time

2. OR Try to use read...

George is Right. Please check if the file is getting corrupted during the transfer over the network.

...

1. Select a Dataflow Task

2. Double Click on it and then add OLEDB Source and OLEDB destination.

3. Put a Data Conversion Task in between OLEDB Source and OLEDB...

For converting into the unicode, you can use a data conversion transformation between the OLEDB Source and OLEDB destination and the in that data conversion transformation change the destination type...

Hi Guys

Thanks for the shaking the myth.

Sorry for...

Or you can use the folowing

USE DB_NAME

GO

EXEC sp_change_users_login 'Report';

-- sp_change_users_login 'auto_fix','user_name'

sp_change_users_login 'update_one','user_name','Login_name'

...

Deprecated in SQL 2005, replaced by SSIS, should not be used for new development, will be removed in a future version of SQL Server.

________________________________________

Gail Shaw

We walk in the dark...

Also... DTS

Thanks,

SQLBuddy

Hi George,

I am ready. Please go ahead!

...

I mean to say that it can't even if we enable the AWE.

AWE is not required on 64-bit machine. So don't in this case too.

...

SQL Server 32 bit can't use more than 4GB of memory. Please use AWE setting for the 32-bit SQL Server and Lock Pages in Memory setting if it is a...