Hi Steve;

I probably should have put a smiley in my first post. It was meant as a light-hearted ribbing.

I personally don't take the scoring for these seriously at all. I...

Whoops.... I'm right and you're wrong. The stored proc syntax is invalid.

Look at line 9:

9 SELECT EmpNo, EmpName, Salary, DOB, DOJ from Employee where EmpNo=292' --Return Value

There's an opening quote...

That's the way I went, too... no "IN" specified in the command line = error. Something obvious we're missing?

Don;

You don't specify in your OP what level you expect to enter as a SQL Server DBA. I would think that with your Access background, you could get on as...

I'm a bit confused by your post. Are you saying you've passed a SQL Server exam, but have no real-world experience with the product?

Both in this example and in the article's example, the column that stores the 'USER_NAME()' and 'SUSER_SNAME()' results is defined as something other than the return value for these functions...

P.S.

Some of your statements about your table indicates that it is not properly designed (i.e., normalized). I'd be happy to work through that with you if you can post...

The VIEW is intended to be permanent... not something you create/delete each time you enforce the constraint.

My script is ambiguous in this respect because I left the cleanup code (DROP...

tymberwyld;

1) Reconsider your table design -- why would you allow NULL UserNames? What does that mean?

2) Here's another (IMO, more elegant) method that doesn't rely on procedural (trigger) logic. Creat...

I would like to commend Mr. Hedgate on an insightful and articulate critique of this article. The two links in his response provide excellent resource for taking a step towards...

quote:

---

I think I understand where you are going...

The only way anything can be written to the production TimeTable is via the stored...

quote:

---

Hi Troy,

Not sure I follow you in regards to incorrect data within the date variables. Could you elaborate?

---

Jon;

I like the idea of having the extra columns available for utility purposes. I think, however, that it's a mistake to define the columns and then populate them as your...