You may need to use the UNSAFE permission set.

2) Why are you using...

Questions:

1) What permission set is your assembly installed with?

2) Why are you using ODBC instead of ADO.NET?

3) Why can't you use a linked server for this?

I wanted to answer your question about HierarchyID a little bit more completely.

HiearchyID appears to have a real upper limit of about 8000 levels (and a practical upper limit of...

GSquared (9/4/2009)

---

Lysdexia is...

Hmm, for some reason I always thought that that word was spelled "cixelsyd". 😛

Fraggle (9/3/2009)

---

:ermm: Sigh.We can argue all day. Fact is fact. At a minimum, you only need 33,000 people in one strait line to break the recursion. Yes,...

Uhm, OK, I'm going to try to counterspell Zantana here, (rattle...

Uh, no, that would be incorrect. I sincerely doubt that AmWay has even 200...

A *much* more efficient data structure would be a "sibling-precedence" type of tree, wherein chains of single-child node levels are actually stored as siblings with some kind of precedence ordering,...

Right. We've actually had this discussion before. I think that the whole structure and are wrong for this.

The "branching level" of a tree is the average...

This is why I say that:

paulj_p4 (9/3/2009)

---

...i want to create a script that will run through all the tables within sysobjects inserting a new primary key called "company" see below...

so...

2) No, the possibilities are too divers. You need to clarify this by showing us what you are really dealing with. For instance: there are *extremely* few legitimate...

1) Nope, not directly.

2) The answer is going to be "it depends", because it depends on your Heiarchies and how your CTE's are setup.

That said, my gut feel is that...

PerfMon has a slew of stuff built-in for SQL Server 2005.

I don't think that is what he's asking. This appears to be a multi-tenant shared schema situation, wherein "CompanyID" is the Tenant ID. As such, I believe that...