Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-10-06 : 20:37:54
|
Hi Could not use view or function 'dbo.DENTIST4_RDHM' because of binding errors.Tha above error is getting because I am running the Maintenance Job which will invoke through the above View.Can Anyone help me in this regardThanks |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 00:58:31
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70138 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-10-07 : 20:47:10
|
Thanks Visakh16I need to give complete description, so that based on that can be analysed and give me solution.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 isCould 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 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-07 : 21:05:50
|
See what happens if you refresh viewswithsp_refreshview 'schema.viewname' |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-10-08 : 20:13:51
|
Thanks a lot. I have already executed with the Sp_refreshview but it is still finding fault with Binding error message.Any help further. |
|
|
|
|
|