You got late by some seconds referring...

Dev (11/30/2011)

---

Not Exactly. CONTROL SERVER has...

This is why I was hoping 🙂 So you keep the situation under control.

Banana-823045 (11/30/2011)

---

Uh, no. CONTROL SERVER was never ever needed for what I needed to do with...

You are missing the point that how would you authenticate to the AD Server? Obviously, with kind of a domain admin user, right? Then what if your SQL Server got...

I cannot understand your point. If you are unable to handle it from MMC (Do not know MSC but do know .msc extensions for different consoles), then why are you...

This is where the Server level DDL Trigger comes into picture. See this link

http://www.sqlservercentral.com/articles/Security/70905/

OR

You can use impersonation/ EXECUTE AS in the stored procedure depending upon your environment.

I would not consider giving CONTROL SERVER permission at any instance as it is equal to sysadmin (with some less authority). Same is the case with security admin server role,...

I am not able to understand why you want to manage Active Directory from SQL server? It is not built for that. As far as managing it by using powershell,...

This would do according to your desired ouput

SELECT * INTO #temp

FROM (

SELECT 2036 AS ID,cast(NULL AS varchar(100)) AS parent,'Sunway GROUP' organization,cast(NULL AS int)parent_id

UNION ALL SELECT 2037,'Sunway Group','10000000',2036

UNION ALL SELECT 2038,'Sunway...

Sorry, but I am still not able to understand it. Should 2039 have to be concatenated, since it has a child 2041 now? Or you just want to see the...

What would be the output for this

ID Parent Organization Parent_ID

-------------------------------------------

2036 ...

Sorry, after looking at the image, this is not what required. Please discard it.

I am not sure, but as far as I understand after looking at your comments and data, this could be what you are after

Declare @SessionDatas table(

...

Cadavre (11/17/2011)

---

Usman Butt (11/17/2011)

---

Following the footsteps of Mr. Jeff Moden, I believe this would be good enough

DECLARE @StartDate DATETIME, @EndDate DATETIME, @MonthDiff INT

SELECT @StartDate = '20091001', @EndDate...