Hi,

I'm trying to transfer a database from one SQL 2005 server to another,
but it fails with the following error:

OnError,APER,NT AUTHORITY\SYSTEM,XENON_SQL2005_APER_Transfer Objects
Task,{77F5D8BC-6D0E-466E-B3D9-BF8BAF4649E0},{3AB546FC-9257-438F-A969-A3E81BD1356C},02/05/2006
11:35:09,02/05/2006 11:35:09,0,0x,ERROR : errorCode=0
description=The column prefix 'tblCategory' does not match with a table
name or alias name used in the query.

I presume this is a bug in an old stored procedure. How can I find out
which stored procedure is causing the problem? Is there a way to force a
syntax check of all stored procedures without manually opening every
single one?

Nick....

Hi Nick,

Thanks for your post!

According to the error message, you need to check all the views and stored
procedures which depend on the tblCategory.

You could open the Management Studio and connect to the database, find the
table tblCategory and right-click it. Click View Dependencies, you will see
all the views and stored procedures and you could check these objects.

Hope this will be helpful.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.