Finding who is connected to a database and disconnecting them

--list the connections - run against master
select spid, status, loginame, hostname, blocked, db_name(dbid), cmd from master..sysprocesses where db_name(dbid) = 'database name'

--disconnect the user
kill 999 --where 999 is the spid from the above statement

Alternative
--list all users in a database - run against the db you are looking into
sp_who

--disconnect the user
kill vid

Importing Active Directory Details to SQL Server

The following script can be used to import Active Directory data into a Sql table.

Note - there is a big limitation with using this - only the first 1000 entries will be selected

You need to initially create the Active Directory database as a linked server.

The script uses subquerys to allow for manipulation in the SELECT Field1,Field2,Field3,Field4 FROM statement and you will have to put in your own AD specific details for the parameters and fields.

Apologies for the code formating problems I had with this - remove the underscores

-- to link AD Server
-- sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'
BEGIN TRANSACTION
  TRUNCATE TABLE AdUserDetails
  INSERT INTO AdUserDetails (Field1, Field2, Field3, Field4)
        -- Select the required fields from Active Directory
        SELECT  Field1,Field2,Field3,Field4 FROM
            (SELECT TOP 100 PERCENT *
            FROM OPENQUERY(ADSI,
            '<LDAP:/ /dc=YourADParam1,dc=YourADParam2,dc=YourADParam3>;(&(objectCategory=person)(objectClass=user)(name=*));AdField1,AdField2,AdField3,AdField4;subtree') AS t
            WHERE AdField3 IS NOT NULL) AS ad
COMMIT TRANSACTION
select * from AdUserDetails

Reporting Services - Setting up Drill Downs

Reporting Services - Conditional Formating

Reporting Services - Ordering Matrix Columns

Column header values from a field you are grouping on will be semi randomly in a matrix report. displayed if specified as follows.

1) Right click on the field to be ordered and open "Edit Group".

dffds
2)
dsfdsfdas fdasf dasf asd fdas fadsaf asdf dasf das fdas fads fda fdsa fdasf asd fasd fasd fha iof oasdjfio;asdjio;f asdiofuioaufiopduaiopfduiopa fuiopdasuiopfasduiopfasdu fuasdiop fuiopasdu fiopasdu fiopasdufi uasdiop fuai





dfsfsdfs

fsdfsdfs

sdfsdfsdf