November 16, 2011 at 10:06 am
I have dropped all of the objects that I created that reference my schema collection. But when I issue the command 'drop xml schema xxx', I get the message:
Msg 6328
Specified collection 'xxx' cannot be dropped because it is used by object 'sys.TT_2937F6EB'
Checking sysobjects this is an object of type 'TT'. I thought perhaps it was related to a database object that I had created, but it has no parents. I am not familiar with type TT and I am not sure how to drop this object. Because this is a development database I am of the impression that this should not persist, but I have not been able to find any information on this object type.
any help would be appreciated.
November 16, 2011 at 10:55 am
Check if you defined a table type parameter that uses this schema.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 16, 2011 at 11:00 am
Thank-you. You are are correct. I had declared variable of type table and referenced the XML collection in the table. Apparently I did not remove the table and it persisted when the procedure was dropped.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply