Viewing 15 posts - 9,001 through 9,015 (of 9,725 total)
AD shouldn't affect what you see in SQL Server.
Can you give me a list of all the settings you've got in SQL on that particular group login? ...
January 30, 2008 at 5:43 am
Triple check all the login properties of the group. Make sure the Server Roles really does have SysAdmin checked. If not, check it. If so, then see below.
Test...
January 30, 2008 at 5:09 am
I've never had to do that. I've always been able to change the owner via the SSMS GUI.
Just to clarify, what I've always been able to do (because the...
January 30, 2008 at 4:53 am
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...
January 30, 2008 at 4:18 am
Ed,
That is an *excellent* way of rephrasing the question! Thanks for that. @=)
January 30, 2008 at 4:16 am
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...
January 30, 2008 at 4:14 am
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...
January 30, 2008 at 4:07 am
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...
January 30, 2008 at 4:01 am
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...
January 29, 2008 at 5:25 pm
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...
January 29, 2008 at 5:23 pm
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...
January 29, 2008 at 11:54 am
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...
January 29, 2008 at 11:45 am
At this point, I would call Microsoft and see if they can clear up the problem for you.
January 29, 2008 at 11:12 am
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...
January 29, 2008 at 10:51 am
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,...
January 29, 2008 at 10:15 am
Viewing 15 posts - 9,001 through 9,015 (of 9,725 total)