That sounds indeed like a difficult case. I don't know enough about Windows to say whether this can be solved and how. And MSDTC is a Windows component.

GilaMonster (9/17/2013)

---

You don't. Every time I've implemented login triggers I've used EXECUTE AS with a login that has access to whatever resources the login trigger needs (and nothing else), along...

Too bad that you are not on SQL 2012 or later, that makes things simpler.

The embarrassing part is that I work a lot with FIFO calculation at work, but not...

Glenstr (9/16/2013)

---

ps. I can see why "with execute as" may not be the correct solution here, if my trigger is tracking all database logons for auditing purposes, then using "with...

That is exactly what you use the syntax graphs in Books Online for.

But as I...

Not that I know, but could it be that the account was renamed in Windows and the added to SQL Server under the new name, and the old name was...

Time to take a step back. You have:

BuildDates.BuildEventType IN (dbo.DelimitedSplit8K(@BuildEventTypes,','));

This is the same as

BuildDates.BuildEventType = dbo.DelimitedSplit8K(@BuildEventTypes,',');

But since DelimtedSplit8K is a table-valued function, this is not going to work out....

It's difficult to understand your question, since you seem to say that you get the result

studenid|SchoolID|year|Att_date|AMAttCode|PMAttCode

7040744|289|2013|09/13/2013|E|null

7040744|289|2013|09/13/2013|null|U

But the last column before the FROM clause appears to be a date.

In any case,...

That depends. If...

Presumably the problem is cause from that dynamic SQL statement the procedure produces. The code is very painful to read with all that uppercase, and the programmer does not seem...

If you have all the words you want to add in a table, you can do

SELECT 'ALTER FULLTEXT STOPLIST MyStoplist ADD ' +

quotename(stopword,...

In that case, there is some other bug. The...

I did some further testing, and I found that when you use the -w option and do not use a format file, BCP skips the BOM. It still does not...

So this is a built-in system function, not a user-defined function. You cannot invoke built-in functions through EXEC. This is only possible with scalar user-defined functions.

Sorry for the nonsense post, and thanks a lot for the question. It came very timely with a text I'm writing, and made me aware of problem with BCP that...