backup logins

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » backup logins

backup logins

Rate Topic

Display Mode

Topic Options

Author

Message

Admingod

Posted Wednesday, January 30, 2013 10:10 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:03 PM
Points: 55, Visits: 569

I got below error message when I run backup logins using schedule job….When I run manually from the Job, instead of schedule it runs successfully.

error: "Cannot get the data of the row from the OLE DB provider "SQLNCLI10" for linked server
returned message "Row handle referred to a deleted row or a row marked for deletion.".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Also, no issues with linked server(i have verified the connection).

Thanks

Post #1413705

opc.three

Posted Thursday, January 31, 2013 5:33 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:21 AM
Points: 6,720, Visits: 11,760

Admingod (1/30/2013)

Is "backup logins" the name of a job in your environment?

Please post the code having the problem.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1414024

« Prev Topic | Next Topic »

Permissions