Need Help on this question - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Need Help on this question

Author

Topic

gourab.guha
Starting Member

2 Posts

Posted - 2009-05-27 : 10:26:02

Can anybdy help me with this?

An user unable to drop a view created in sql server.
This view has:
a. A function with WITH SCHEMABINDING on linking to the view
b. A user role linking to the view
c. A trigger to the view
d. WITH SCHEMABINDING on the view

To delete the view, what is required:
i. Remove SCHEMABINDING from View
ii. Remove SCHEMABINDING from function
iii. REMOVE TRIGGER
iv. REMOVE linkage from Role

Waiting for a reply from any one of you...

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2009-05-27 : 23:47:58

I'd suggest you try it...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources