February 10, 2003 at 10:56 am
I get the following error when my maintenance plans run:
Logged on to SQL Server 'SQL01' as 'DomainName\UserName' (trusted)
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.
I have made sure that the login is a local admin on SQL01. Additional info is that I am using Multi Server Administration. The maintenance plans were created on the master server and then SQL01 became a target server and all the plans were propogated to it. I have other target servers using the same plans without problem. The master is Windows NT 4.0. SQL01 has Windows 2000.
Has anyone seen this error and/or know how I can resolve it?
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
February 10, 2003 at 12:44 pm
Is seems that the problem is on the T-sql inside the plan. Check what the plan does and check any difference with other target server. If you are acceding the OS, check if you have the same directories, or the same tables, data types, etc in the database.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply