not sure what you need from Active directory, but something i do once a week via PowerSell is to query AD, and put the result sin a SQL table in...

xp_cmdShell for the commandline script already provided, but i'd bet there is a 90% chance...

metroman17 (4/29/2015)

---

I see application users in the application but I do not see them in the database as users ?

These app users can connect to the database using their logins.But...

certainly, with more information.

map to what? active directory? a separate table? SQL users to SQL logins?

give us a bit more detail what you are after.

test Successful!

if your profile is set up right, you probably got an automatic notification due to this follow up post to your thread.

ALTER statement always adds columns to the end. it does not support identifying the column_id and stuff like that.

SQL doesn't really care the order of the columns , but...

looks like his table is an Entity-Attribute-Value model, so he uses the same table multiple times for various lookups.

most recent edit no matter what(so one row, period) or most recent by EntityId?

your current logic groups by GROUP BY EL.Id, which is probably the Identity() column of the table,...

i'd expect either the keyword IN or OUT to exist in the query, right?

bcp STATRLO.dbo.PM-allactivity-emaillog_042315 in format nul -c -t, -f C:\database\Activity_c.fmt -S stat-hp\sqlexpress - T

i always use query out...

adam-639168 (4/24/2015)

---

There is a table function that returns results based on the account parameter that is referenced.

e.g. select * from dbo.mytablefunction(ACCOUNT)

I have a list of accounts in a different table...

create either a server side trace or an extended event that captures errors. then you can review them at your leisure.

you can limit it to certain tspecific error values if...

forrest77 (4/24/2015)

---

Hi, I tried the distinct and it did not work. the issue I'm having is when I join on this table to create a report, I get multiple...

i'd stick with the explicit commands that Gail suggested, but

this worked fine for me when i quick tested it, but if you want it to occur at specific times, it...

ok, so you have ~3000 users in active directory;

did you add a login for a windows group like myDomain\RegisteredUsers? or did you do user by agonizing user ~3000...

same table? sure:

UPDATE Customer

SET UpdatedDate = CreatedDate

WHERE UpdatedDate IS NULL

AND CreatedDate IS NOT NULL

different table ? if you can join the tables together, then yes.

UPDATE Customer

SET VerifiedDate...