Viewing 6 posts - 1 through 6 (of 6 total)
Son-of-a-gun! You're right!
I thought I looked at this function prior to submitting this forum entry, but in retracing my steps, it appears I looked at the "suser_name()" function instead....
January 28, 2010 at 12:57 pm
I took a look at the sp_help_job procedure by listing its text with sp_helptext but I don't see a call to the xp_sqlagent_enum_jobs procedure. But other references make the...
January 26, 2010 at 4:33 pm
Thanks, Jeffrey.
I think I agree with you that the name is probably coming from outside of SQL Server and your explanation makes a kind of Microsoft sense. 🙂
Thanks, again.
January 26, 2010 at 4:17 pm
Thanks for the KB reference.
My question isn't so much about how users are authenticated, though, but more about how SQL knows who "owns" the job even though the...
January 25, 2010 at 4:43 pm
Yes, I have looked in sys.server_principals and sys.sql_logins and neither of those views seem to hold the answer to this riddle; which is one of the reasons this is so...
January 25, 2010 at 2:22 pm
We've had problems with the OraOLEDB.Oracle provider in the past. We switched to the MSDAORA provider and have had no difficulty since. Just something to consider.
August 31, 2007 at 1:30 am
Viewing 6 posts - 1 through 6 (of 6 total)