Wow, that is a lot. Thanks.

I got an error when using this script in SQL Server 2012 SP1 -

--BackupFile restore (JensS@Microsoft.com), 08.09.2011 V0.2

--=========================================================

--Generating command for found file \\p015\Sql_backup\$DEV2\DBname\FULL\$DEV2_DBname_FULL.bak

Msg 213, Level 16, State 7, Line 1

Column...

This proc crashes if there any database offline -

Msg 942, Level 14, State 4, Line 2

Database 'db1' cannot be opened because it is offline.

After reading tips in the article from sybase at this link ( http://www.sybase.com/detail?id=1056225&EMC=notificationmysybase&attr=1056225 ) I was able to install the 64-bit ODBC driver and subsequently create a linked...

Wonder if there is any 64-bit ODBC driver for Sybase that can be used instead of ASEOLEDB provider.

I tried to add a linked server on SQL Server 2008 SP1 64-bit on Windows 2008 standard server, using ASEOLEDB provider to connect to a Sybase database. Did register it...