First thing I would check is to make sure that the SQL Account does not have the password enforcement enabled.

Agreed unless you can get the same results by eliminating the index viewed rules. Such as instead of using the view use the 2 tables. Sorry can not help any...

Dear

I allready set up replication of an indexed view. It creates a new table (same layout as the indexed view) in the subscriber database.

So that works perfectly.

Now i...

i taught it was the best to use the replication software of sql server itself.

It works perfectly with indexed views if i do not use left joins

So i taught it...

i want to replicate fields out of 4 5 tables that are joined with 'left joins' and want that the replication creates a new table at the subscriber site with...

I far as I know you can not create a index on a view that has a view or sub table in it.

http://msdn.microsoft.com/en-us/library/aa933148(v=sql.80).aspx

Then do what it says Run DBCC UPDATEUSAGE on it. Here how to use this command. http://msdn.microsoft.com/en-us/library/ms188414.aspx

Start by looking at the error log if you do not know the location you can check it in SSMS. Look under Management>SQL Server Logs>Current<date>

Have you opened up this Maintenance plan? (Transaction Log Backup.Subplan_1) To see what is going on in it? Is it failing? Try changing the ownership of the Job.

I suggest that you check both logins sys.database_permissions: http://msdn.microsoft.com/en-us/library/ms188367.aspx

But do you have the permissions to use it?

Have you run down the obvious, like do you have the appropreate rights? Or You need to run under correct database and correct schema.

opc

Its deja vu.

Then try this should work for OpenQuery:

declare @cnt int

select @cnt = cnt FROM OPENQUERY(SDW, 'SELECT count(*) as cnt FROM PHARMADM.PHARM_HRXS where POSTED > to_date(''07/11/2011'' ,''mm/dd/yyyy'')')

select @cnt

Then what is the purpose for the variable? A little more info in what your trying to do would help.