March 26, 2008 at 3:44 pm
Isn't anyone using ad groupnames of more than 25 chars ?
sp_helpuser is truncating ad-groupnames to 25 characters
It uses sp_helpgroup wich contains the dodgy substring(name, 1,25)
Isn't anyone out there having the same problem ???:blink:
According to MS we're the only ones ... so we'll have to go along with the workaround.
I.E. copy both procs, create them in the dbo schema in master and make them as systemobject for database transparency.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 27, 2008 at 3:39 pm
We've run into it ourselves and try to keep them short as a result. Yeah, I agree... but what can you do?
K. Brian Kelley
@kbriankelley
March 28, 2008 at 12:49 am
Thank your for the corroboration. I was feeling very alone 😉
Indeed, you cannot do a thing about it, but open a case at MS (because it actualy IS a flaw) and hope for the best.
The workaround is just copy the current procs, modify them and use them in the mean while.
And just in case they might fix it, pepare a revert back scenario for usage (as few as possible).
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 28, 2008 at 6:29 am
If it makes you feel any better, it's my particular department that has the current group problem since we once had a name that pushed us over the 25 characters. If you look at the pre-Windows 2000 name, that name can be used to grant access, but it's something we have to think about every single time. Quite annoying.
K. Brian Kelley
@kbriankelley
March 28, 2008 at 7:18 am
Actualy , today I had contact with MS, and it turned out to be a flaw in SP_Helpuser (since SQL2000 RTM)
SP_helpuser calls sp_helpgroup wich truncates this to 25 chars.
If you use sp_helprolemember 'uRole_xyz' you're OK.
(actualy that's the proc sp_helpuser should use, but it has not been modified for it)
I guess, since sp_helpgroup nolonger exists in sql2008 (MS checked it) , sp_helpuser got adjusted to use sp_helprolemember too.
(I have no sql2008 available for the moment)
Maybe this helps you also a bit in the right direction 😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply