default value of username 1

[jmeckley]

I would like to make the default value of a field the user's username. This is my first assignment working with SQl Server 2000. In Access I could set the default value to '=environ("username&quot'. I have quickly learned that this does not work in SQL 2K.

I am building the app in ASP.NET for internal use only. I think the most effecient way to get the info is through a default vaule assigned to the column or a trigger that would insert the username and date/time into their respective fields.

I got the datetime to work using the getdate() function. Any ideas on how to go about capturing the username? Thank you for your assistance

Jason Meckley
Database Analyst
WITF

 

[tlbroadbent]

Set the default to SUSER_SNAME(). If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[sunila7]

Hi,

Set the default value of the field to suser_sname(). Havea look at BOL (Books Online) for more info

Sunil

 

[jmeckley]

when you say BOL do you mean generic web site tutorials or a specific webpage that most DBA's find informative? Thank you for your assistance

Jason Meckley
Database Analyst
WITF

 

[SQLSister]

Books Online is the SQL help that comes with SQL Server. YOu can find it by cliking the help button in ENterprise Manager.

 

[sunila7]

Hi,

Have a look at this link....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_86xx.asp

SQL BOL is the Help that comes with SQL Server u can also get from msdn....

Hope it helps

Sunil

 

[tlbroadbent]

Read faq183-689, "What are SQL Books Online & Where Can I Find Them?"
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm