Viewing 15 posts - 6,256 through 6,270 (of 7,636 total)
Rats. It's much easier to come up with reasons why it might lose the SID mapping to AD.
Have you tried SELECT * FROM SYSUSERS when this happens?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 10:12 pm
Yes, what were you thinking that @user-id = UserID? 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 10:04 pm
I had a similar problem, also two years ago. Unfortunately, my recall is worse than Gus's, but I do remember that I had to pitch Window's authentication and use...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 6:15 pm
Are these SQL accounts or Domain accounts?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 6:06 pm
Change the provider and the connection string and the rest will probably work as is.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 6:04 pm
Jack Corbett (7/21/2008)
You can actually eliminate the reference to the tblUsers table altogether and just do:
Actually, Jack, [font="Courier New"]@UserID[/font] matches to [font="Courier New"]UserName[/font], not [font="Courier New"]UserID[/font].
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 6:02 pm
My suspicion is that SSMS is keeping track of the transaction identities or else is receiving notifications for the transactions that it creates and thus knows that you have canceled...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 5:01 pm
What error do you get?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 3:57 pm
Jacob Pressures (7/21/2008)
I'm using VB6 with ADO.
In that case, I'd suggest that you stick with AppRoles. When combined with good stored procedure security, they provide very good ROI, security-wise....
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 3:46 pm
Michael Valentine Jones (7/21/2008)
It’s not arrogant if you can back it up.
No, actually, it is arrogant if you can back it up. If you can not back it up,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 1:02 pm
Brandie Tarvin (7/21/2008)
And yet a poorly written ETL process could inadvertantly orphan records.
Well, that's an argument for code reviews & good testing, not Triggers in the DW, remember,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 11:51 am
Jonathan Kehayias (7/21/2008)
What version of Oracle and is SQL running on x64 or x86?
Oracle 10g. SQLServer 2005, x86 for development and test, x64 is the production target.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 11:19 am
Jonathan Kehayias (7/21/2008)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 10:48 am
b_boy (7/21/2008)
Hello AllI kinda found a way which is KISS (Keep It Simple and Simple), i used in my select query:
WHERE[ExpiryDate] BETWEEN getdate() AND getdate() +30
??? So I guess...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 10:01 am
dlongnecker (7/21/2008)
Sweet, thanks.That should work because i'm doing this in a small database with few users. But is there a way to do it that isn't a triangular join?
Like this:
Select...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 9:34 am
Viewing 15 posts - 6,256 through 6,270 (of 7,636 total)