Hi Adi.

Thanks for the reply.

In my database, I have a user account (winfas) aliased to dbo. When I run sp_helpuser in that database, I get two result sets. ...

I'd like to see this kind of article geared towards DBA's rather than developers. The Backups one would be a definite for both though.

Steve Jones - Editor (5/27/2009)

---

The newsletter is what the question goes out as, but it could potentially be changed if we find issues. I'm not sure what you want. Do...

Argh! The question changed from the email and I didn't read the web page's version of the question!

I've found one privilege so far:

in master, EXECUTE on sp_fulltext_getdata granted to the MSFTEUser group.

I have an unmodified AdventureWorks database. 1 and 2 work fine. 3 and 4 fail.

3 gives:

Msg 207, Level 16, State 1, Line 2

Invalid column name 'EmployeeId'.

4 gives:

Msg 8127,...

kozloski (5/20/2009)

---

You could also use the xp_loginconfig extended stored procedure, although it comes with the dire warning in Books Online that it "will be removed in a future version of...

That's just what I...

bob.willsie (5/13/2009)

---

However, the right exercise did. I place a bowling ball between my legs, bend over, and lift it up shoulder height with my arms straight. The key...

Thanks Steve!

Interesting approach. This gives me something to work with. Thanks for the script George. I appreciate it.

I got "0" and the warning in 2005 SP2. The "0" was on the Results tab and the warning was on the Messages tab.

Oooh... dynamic sql. And it is fine with the multiple lines being crammed together. I just added the "insert into #mytemptable" at the beginning and it does...

Jeffrey: your help has been great. Thank you.

Everyone/Anyone: I'm still working on this problem. Currently I'm trying to do something like:

select name, (exec master..xp_logininfo @acctname = name,@option...

Yes, please keep it simple. I'm an Oracle DBA who now has to also run MSSQL databases. I don't know VB, .Net, C#. I'm learning some TSQL...