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?
July 21, 2008 at 10:12 pm
Yes, what were you thinking that @user-id = UserID? 🙂
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...
July 21, 2008 at 6:15 pm
Are these SQL accounts or Domain accounts?
July 21, 2008 at 6:06 pm
Change the provider and the connection string and the rest will probably work as is.
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].
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...
July 21, 2008 at 5:01 pm
What error do you get?
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....
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,...
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,...
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.
July 21, 2008 at 11:19 am
Jonathan Kehayias (7/21/2008)
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...
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...
July 21, 2008 at 9:34 am
Viewing 15 posts - 6,256 through 6,270 (of 7,636 total)