OK, so I recreated the table without the identity column, and hey presto, minimal logging taking place.

So it would seem that the identity insert was causing the problem. I'll...

Yep to confirm:-

1) The table isn't replicated.

2) Table locking is specified in the INSERT ... SELECT statement.

3) The target table is empty. (It has a clustered index and no non...

I think you need to move the ROLLBACK to before the mail send and raiserror, this will ensure that the ALTER DATABASE statement is rolled back but then allow the...

In order to have a string with an apostrophe, you need to use two apostrophes together, eg

Insert into table_Name values (2,'Text''s')

A table can only have a single clustered index and a single primary key. However these do not have to be the same; you could have a non clustered...

Try this:-

SELECT

(SELECT custname AS CustName

, custcode AS CustCode

FROM @test-2 t1 FOR XML PATH('Item'), TYPE)

FOR XML PATH('Header'),ROOT('ns1')

Ok, seem to have a work around; create the foreign key with NOCHECK but no NOT FOR REPLICATION, then run the alter statement with check eg:-

ALTER TABLE [dbo].[Debtor] WITH NOCHECK...

You need to use the NORECOVERY mode for the restore. The upgrade occurs at recovery point, which is why you can't use STANDBY.

Is this a remote connection? It sounds like a named instance, so have you got the SQL Server Browser service running?

Have you checked that Named Pipes is enabled for the...

Probably want to start here:- http://msdn.microsoft.com/en-us/library/ms151198.aspx

The clue lies with "The system cannot find the path specified".

Check that the path you have specified for your backups exists and that the account log shipping is running under...

You can create logins in SQL that target an Active Directory security group. Then you can create the database users as appropriate for that login.

If you don't have a...

OK try this:-

WITH cte AS (

SELECT d1.IDXMRN

FROM Diagnosis d1

INNER JOIN Diagnosis d2

ON d1.IDXMRN = d2.IDXMRN

WHERE d1.Code = '305.1'

AND LEFT(d2.CODE, 3) = '491'

GROUP BY d1.IDXMRN)

SELECT d.*

FROM Diagnosis d

INNER JOIN cte

ON d.IDXMRN...

Try this:

SELECT IDXMRN, Problem, Code FROM Diagnosis

WHERE Code = '305.1'

OR LEFT(Code, 3) = '491'

Or have I completely missed the point, and you want the IDXMRN where there is a row...

I think your starting point is to look at which account the job step is running under.

If that login does not have the VIEW ANY DATABASE permission, then a query...