Monday, March 12, 2012

Removing Sql server 2005 user defined type

I have a user defined type that i am trying to remove from my database. When
i check it's dependencies, it references itself. I've removed the fields
that used this type but I still can't drop it. Any help would be appreciated
Thanks
--
Live long, stay strongCongero,
Have you tried sp_droptype? Also, check the db fixed role memberships of
the db user you are using to drop the udt.
See:
http://msdn2.microsoft.com/en-US/library/ms189765.aspx
HTH
Jerry
"Congero" <congero@.congas.com.nospam> wrote in message
news:B32C9E29-14A8-4AA6-B9E2-C7E535CDDA9B@.microsoft.com...
>I have a user defined type that i am trying to remove from my database.
>When
> i check it's dependencies, it references itself. I've removed the fields
> that used this type but I still can't drop it. Any help would be
> appreciated
> Thanks
> --
> Live long, stay strong

No comments:

Post a Comment