Have you tried retrieving the error logs from the \LOG directory using a text exitor?

What does it shows in the current error log?

I guess so.

Transformation? You have not mentioned anything about transformations until now and what transformations to use depends on...

Unless someone who wants to help is already aware of...

This is not a complete solution since there is no table DDL, and column details and I am not advanced level developer ( I am a DBA)

Construct a Temp Table...

George is right. In what way is it Hot Standby Server.

If it is a Hot Standby Server why are you planning to detach and delete the databases?

Have you got...

Under TSQL

Choose the 2 events SQL:BatchCompleted and SQL:BatchStarting

Welcome!

Are you from Hydbad?

The error seems to be with variable also, not just the security permissions.

Check the variable name reported in the error msg and see if that variable is out of that...

NO! SQL Server does not need to restart.

You can edit a .bat file (batch file) from any text editor, including notepad.

jayoub1 (12/14/2009)

---

I have SQL 2005 running on a Windows Server 2003 and I have a question about Buffer Cache Hit Ratio and Page Life Expectancy

First: What does Buffer Cache hit...

When you use that security setting,...

You are welcome !

What abt server details you are using when creating Linked Server.