Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JustinBigelow
SQL Gigolo
1157 Posts |
 Posted - 2001-05-15 : 13:17:18
|
| Hey all,I wrote sproc that takes a user name as a parameter and it worked just fine. I tried to alter it and give the parameter a default of suser_sname() but compiling it I get an error message Line 1: Incorrect syntax near '('here is my dec...alter proc sprocUserActivity @user varchar(40) = suser_sname()as...It has to be something simple but I can't seem to figure it out. Thanks,Justin |
|
|
|
|
|
sproc parameter error