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
 Dropping XML SCHEME COLLECTION

Author  Topic 

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-07-03 : 08:25:37

Hi Gurus,
I am trying to drop XML SCHEME COLLECTION

But ia m getting error as

Msg 6328, Level 16, State 1, Line 2
Specified collection 'xxxx' cannot be dropped because it is used by object 'dbo.yyyy'.

can i alter scheme ?

Or do i need to drop the dependencies ?

Thanks,
ServerTeam

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-03 : 10:37:04
Did you check this one?
http://msdn.microsoft.com/en-us/library/ms189448.aspx
Go to Top of Page
   

- Advertisement -