This has nothing to do with the log shipping process but rather with the reporting of the backup process.

As you pointed out, log shipping is working fine.

Check the following things:

What...

Hi,

Sounds like there's a problem with your primary server not being able to talk to the monitoring server - or it's not being set up right.

Check that the primary server...

Hi Sumit,

are you calling the same procedure 15 times or are you calling 15 different procedures within the cursor?

How many records are there in the Table?

I'd recommend that you eliminate...

Hi Henrik,

Both the columns_updated() and update(colName) just check to see if a column is updated (physically).  The fact that it has been updated to the same value is irrelevant as...

You cannot implement row level security in SQL Server 2005 (out of the box).  You'd have to design and implement your own implementation of row level security using views or...

Hi,

Can you be a bit more specific about what you need?

Hi,

It sure sounds like there is a potential problem with the hardware.  Just because you can see the lun and get to the folder doesn't mean there's a problem.  There...

Indeed @@identity is another option.

However, because @@identity is not limited by scope I always recommend using scope_identity() instead.  Otherwise you could end up with potentially the wrong identity value.  Of...

Hi Steve,

Do you mean that you want to get the value of the identity that has just been created by the insert?

To do this you can use scope_identity(), like so:

Ravi,

given the error message it is unlikely that there is another cause.  In other words, chances are that there is a connection to the database - whether it's your user or...

Hi,

Given that it is an ID field there shouldn't be any reason why you cannot (or shouldn't) have it in the GROUP BY clause.

Essentially though, it's not possible.  If you...

Could it be possible that the log shipping restore job is attempting to restore a log at that point in time?

Just because you cannot see a connection the db doesn't...

Ah ok, I see.

To grab the last identity value that was generated you should use the @@identity or scope_identity() functions.

Generally I would recommend using scope_identity() as this is restricted to...

Hi James,

Use sysname as the datatype.

The truncate table statement must be dynamic and can be written as follows:

exec

('truncate table '

Hi Paul,

There is an inherent problem in what you want to achieve.  By putting a trigger on table B you are saying you want to handle inserts on table B in...