ddimarco@mastellone.com.ar

Question

Post reply

ddimarco@mastellone.com.ar

danieldimarco

SSC Journeyman

Points: 94
More actions
September 23, 2002 at 11:25 am

#158910

i have the following error in the script.
Logged on to SQL Server 'server' as 'usr' (non-trusted)
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the
range of the specified query result set.
the scripts run the syntax:
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmaint" -S server -U usr -P usr -PlanName BackupBasesALSQLxNSR -WriteHistory -VrfyBackup -BkUpMedia DISK -Bk
UpDB "S:\Backups" -DelBkUps 1DAYS -BkExt "BAK" -CrBkSubDir
any idea ?
thank.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Is the database name correct? Why would you run a script to create a maint plan? Curious is all!

Andy

http://www.sqlservercentral.com/columnists/awarren/

Andy
Connect with me on LinkedIn

akshay.search SSC Rookie Points: 28 More actions · Answer 2

danieldimarco,

Did you find the solution. I am stuck in the same problem.

Akshay Dange

Sean Lange SSC Guru Points: 286609 More actions · Answer 3

akshay.search (3/1/2012)
danieldimarco,
Did you find the solution. I am stuck in the same problem.
Akshay Dange

Please note this is a 10 year old thread...

Did you try google???

Search for "Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set." You will find a whole series of posts, the top one from this site that explains a resolution.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

akshay.search SSC Rookie Points: 28 More actions · Answer 4

Hey Thanks,

I did not find the answer from any of the post. But I figured it out.

Thanks once again.