Home | User-Defined Functions | Tips & Tricks | SQL Server 2005 | Forums | Frequently Asked Questions | Practice Test |    
SQL Server Helper Forum
SQL Server Helper Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000/2005
 Database Administration
 view or function: because of binding Errors
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pdset

1 Posts

Posted - 10/07/2008 :  15:21:02  Show Profile  Reply with Quote
Hi All,

THis is my first ever posting hopefully will get beneficial Reply.

I have setup with new server with different name and copied the whole contents of the existing to new server.
when I am accessing the table info using simple Select statement is ok.

when I am accessing the view info using by means of Select or running a Job : ERROR is

Could not use view or function 'View or Function Name' because of binding errors.

When I checked into answsers from this forum I see it is the column in the table might have dropped for which this error occurs.

But, I get with ALL the VIEWS with the above error.

Could anyone help me in this regard.

Thanks in Advance

tosscrosby

USA
12 Posts

Posted - 10/08/2008 :  11:54:10  Show Profile  Reply with Quote
I Googled and found this. Not sure if it applies:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2825044&SiteID=17

My questions, if you open the view definition, is it looking for a specific server name or database name (if you're using two or four part naming conventions)? How did you move the database, backup and restore? Detach and and re-attach? It may be as simple as running Alter View or Drop/Create Views. Let me know what the answers to my questions are and I'm sure will come up with a resolution.

Thanks,

Terry
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
   
SQL Server Helper Forum © 2006 SQL Server Helper Go To Top Of Page
Powered By: Snitz Forums 2000 Version 3.4.06