Although not mentioned in the documentation, W stands for WeekDay. You can see this if you hover with your mouse over the W.

I guess that's probably the same as Day?

Anyone with a better grasp of SQL Server security and auditing can take this one?

http://www.sqlservercentral.com/Forums/Topic1534372-2799-1.aspx?Update=1

Akayisi (1/24/2014)

---

Hi Koen, the reason why i want to...

Maybe it's a good idea to provide sample data when you initially ask the question.

Check the first link in my signature on how to ask questions.

SELECT

Id

...

It seems the deployment wants to create the folder "Data Sources", but it fails since it already exists.

How did you configure the property for the folder?

ALTER ROLE (Transact-SQL)

The question is: why would you want to. The user is sysadmin so he/she can already do everything.

Nice question, thanks.

Is there a question?

You didn't specify an ELSE clause, so if cffit.IdentifierId is neither IIN or IMS, you will get a NULL value.

Great question and a very nice explanation.

sneumersky (1/23/2014)

---

I have a bad tendency of pushing just Kimball, when in fact there are other schools of thought out there. On this site, I tend to lean way...

Jeff Moden (1/23/2014)

---

Koen Verbeeck (1/20/2014)

---

That statement is not justified at all.

Why...

I get the...

Maybe the last file has some erroneous data?

It's more likely that 64-bit SQL Server is trying to use a 64-bit JET OLE DB provider, which doesn't exist.

You could try to use the 64-bit ACE OLE DB provider...