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
 Drop view is taking long time

Author  Topic 

sree25
Starting Member

5 Posts

Posted - 2015-03-31 : 15:29:10
Hi,

I am trying to Drop a view which is taking more than 40 minutes..Is there any reason why it takes so long time?
do i need to use any hints to make drop command run faster?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-31 : 15:39:01
could there be a query that is currently using the view?
Go to Top of Page

sree25
Starting Member

5 Posts

Posted - 2015-03-31 : 20:28:01
No nothing is running against this view
Go to Top of Page
   

- Advertisement -