I got my points for to give the wrong answer!, but now I must agree with those who disagree. ¡Give them back my points!

Brad:

If you are using the SQL Server Enterprise Manager and you have open the task 'Generate SQL Scripts' for a selected object, press the 'Preview...' button on the tab...

I disagree about this with you, PaulR. This kind of question give us non-Administrators the chance to LEARN about uncommon topics, sometimes to find the answer to an unsolved SQL...

quote:

---

Why not session_user ?

---

Because session_user returns the database user name, not the login name.

...