I am getting this error today, OS is 32 bit and given the read/write permissions to the Temp directory, still getting the same error

SSIS Error Code DTS_E_OLEDBERROR. An OLE...

You can have 2 steps in the same job to execute one after other.

The 1st Step is your 1st Job and 2nd Step is the 2nd Job

I could bring all 3 user DB's online from Suspect Mode by detaching and reattaching them.

The reason of User DB's not recognized by the server was the DB Owner (The...

Hi Ahmed,

Not yet coz, the process which was followed has been finalized in the discussion so I am trying to find the solution from my first approach currently.

If I do...

I've copied all .mdf, .ndf and .ldf files of 3 User DB's to server B in the same location as they were in Server A.

The Master, MSDB, Model has come...

I've copied the user DB files in Server B to the same location as it they were in Server A, so that when SQL Server restarts (Server B) it should...

Hi Ahmed,

Thanks for your reply, the issue is all User DB's are in Suspect Mode now.

How to move Master database between win 2000 and Win 2003 servers.

As I've followed...

The service account was not in the Administrator group of the system, after adding it into the Administrator group and restarting the instance services, this issue is resolved (SQL Server...

Hi Vidya,

Thanks for your email.

I've added the 3rd Instance Service Account as Administrator in the system and also created

a login with SysAdmin permissions. Still I see no change.

Could you please...

An update, later we came to know that Congos is Cluster aware with SQL Server 2005 Named Instance...

Thanks

Thanks for your email.

this probably means the profiler trace should be running during the time when I want to check the SP running.

is anyother way (like, query, feature, etc)

thanks again...

Hi Peddie,

Thanks for your response and the clarification on UTF-8 and UTF-16.

The issue which i was encountered was not with SQL Server, it was a problem with Cognos.

Cognos is...