Hmm. Except it...

I think I shall do just that. Thanks, Koen.

No. It's configured in the ForEach container.

Doooughnut.

Hey, guys. I'm going to post something and if it's inappropriate, please let me know.

A lot of people have been displaced due to the recent East Coast flooding and the...

Someone please explain to me why donut shops insist on placing single donuts in the bag icing side down. I don't want my icing sticking to the bottom of the...

Michael Valentine Jones (7/5/2012)

---

Brandie Tarvin (7/5/2012)

---

Michael Valentine Jones (7/5/2012)

---

Create a calendar table with a row for each date, and include a column that indicates if a date is a working...

Not knowing which of my three suggestions you want an example for, I'll give you the trigger:

--Table is the user table you're logging....

Giving a W.A.G. because it's been a long time since I learned my AD security... SQL Server is acting with your user credentials in SSMS rather than the service account...

bcsims 90437 (7/5/2012)

---

SQLRNNR (7/5/2012)

---

crookj (7/5/2012)

---

Ray K (7/5/2012)

---

Monday (at least it feels like it -- I hate when holidays fall on Wednesdays!)

(For the benefit of those outside the USA, that was...

Can you add the account via the SSMS GUI? Or does it error out when you hit "OK"?

Please post CREATE TABLE statements for your tables in the query. Please post INSERT statements with multiple rows of sample data for us to run the query against.

It would help us to help you if you could post some DDL and sample data in the form of INSERT scripts. Then post an expected result and a copy...

Have tried loading your entire query into a variable first and doing EXEC(@MyVar)?

Can you run the create login statement by itself without the variable & dynamic SQL?

You could try logging this with a DDL trigger or coding your own version of an audit by using the undocumented deleted table.

Or you could simply set up some operational...