Sorry, Can't help you with that! They need to recomile those objects.

You must have permission to do so! Or, ask the DBA that manages the remote server to do that, make sure you tell him to use SQL Management Studio (SQL...

Here's what you need to do to fix this problem:

1- Drop and recreate the view on the Linked Server (use SQL Server Management Studio)

2- Also, drop and recreate the view...

Thanks Prasad!

I'm looking for this as part of a migration to Sybase. Sybase doesn't support user defined function.

DD

The Backup media you took was invalid.

Backup the database again and then use the restore statement.... It should work fine.

Here is an example:

RESTORE

DATABASE...