I'm a little bit confused, then. How can the group have sysAdmin access if the group doesn't have a SQL Server Login?

Check both the server security section and sp_helplogins...

Ed,

That is an *excellent* way of rephrasing the question! Thanks for that. @=)

Actually, you have 2 options, but both are a LOT of hard work.

1) restore a pre-conversion backup to SQL 2000. Change the stuff you changed the first time around...

That's a promising conversation indeed! And I completely agree with Matt. Find out what sort of stuff their DBAs do.

Regardless, you'll still want to learn Security (BIG ISSUE...

Have you tried changing the owner to the Group instead of the individual and leaving it that way? You might not get the same error. In fact, it...

I get probably 20 - 25% correct at max. But every time I get one wrong, I read the reasons I got it wrong and make a mental note...

Okay, I have more copies of "Pirates of the Blue Kingdoms" in my hot little mitts. (Just in case you were waiting for this to place an order).

If you want...

Lynn,

I actually do have a good idea of what the dimensions and facts are looking like (and have gotten those questions answered). This is actually one of the dimension...

I just downloaded a trial version of this and it won't open any of my current Erwin diagrams. Bleargh. It seems nothing I can find will allow me...

At this point, I would call Microsoft and see if they can clear up the problem for you.

I am literally loading three types of values. Money (for financial buckets), bit fields (for determining if someone is a reseller or a direct seller and for determining if...

Ahhh... Interesting that the following statement will work perfectly:

INSERT INTO TESTVARIANT (ITEM) (Select Convert(money,(15)))

And SUM() still will not work with the datatype. I thought it would. In fact,...

I've actually already started adding semi-colons because there are times where it seems to help my code perform better (I guess because SQL doesn't have to decide if one of...

Wow. These are all very interesting suggestions. I'm glad I posted this topic. @=)

I've had difficulty figuring out how to use CTEs with my normal code needs and...

Not having used sql_variant before...

I was under the impression that sql_variant stores different datatypes in the same column. That you can determine which datatype to use for a specific...