Yes, 0 & 2 both work; 1 & 3 both fail.

OK, I have it, tried it and get the same error.

This appears to be a simple length limitation in XML. removing any one text character makes the error go...

oops, almost forgot: attach it as a separate file.

Matt makes a great point. We really need the DDL's also.

Sorry, I am pretty sure that the only ways for you to return information from a function are through the Function return value itself or else as an exception. ...

We cannot read this very well, the tags all got eaten by the BB software. Could you please re-edit it with the editor at this link:http://extras.sqlservercentral.com/prettifier/prettifier.aspx and re-post it?

Thanks,

When you did this, did you use "WITH [NOLOCK]"? If not, try it with NOLOCK, you...

You need to put the verb "EXEC " in front of the ""sp_detach_db"'s in order to execute them.

You can get away without it only for the first command in a...

Robert A. Schottland (5/27/2008)

---

Personally, I use a border collie to sort sheep and goats, but as intelligent as she is, I don't think she would be able to tell a...

Yes, absolutely. Try it.

I always forget where they hide...

Show us the whole procedure. Not just the DELETE query. The other parts of the procedure are important to this also because they are all part of the...

Well, your not giving us much of the context there, but try doing a DELETE TOP (10000) instead, with a WHILE loop around it that loops until @@ROWCOUNT=0.

Of course, I...

Not sure if this is your problem, but I don't think that you can do that from a CLR function. SQLFunctions have a great number of restrictions on them....

Adam Machanic's books are excellent: Expert SQL Server 2005 Development and Pro SQL Server 2005.