Does this give the expected outcome

CREATE TABLE #Surgery

(CaseID int,

Patient VARCHAR(10)

)

INSERT INTO #Surgery VALUES

(101,'SallyDoe'),

(102,'JohnDoe')

CREATE TABLE #Anesthesia

(

CaseIDINT,

CrnaID VARCHAR(10)

)

INSERT INTO #Anesthesia VALUES

(101,'Melvin'),

(102,'Bart'),

(102,'Jack')

CREATE TABLE #AnesthesiaTime

(

CaseID INT,

CrnaID VARCHAR(10),

TimeIn CHAR(4),

TimeOut CHAR(4)

)

INSERT INTO #AnesthesiaTime VALUES

(102,'Jack','0800','1030'),

(102,'Bart','1030','1130'),

(102,'Jack','1130','1215')

;with...

Table

You can use xp_logininfo to enumerate the members of a group

EXEC xp_logininfo 'DOMAIN\GroupName', members;

The following will find all deny permissions on objects

select

accounts.name AS UserName,

OBJECT_NAME(major_id) AS Object,

permission_name,

state_desc

from sys.database_permissions perms

inner join...

Ah, ok, I have never run into this issue in the past, but will keep it in mind should I encounter it.

MS recommendations is to filter out anything with a page count less than 1000

Then reorg anything less than 30% fragmented and rebuild anything greater than 30% fragmented.

SELECT

case when avg_fragmentation_in_percent...

Generally I put 0 in TCP Dynamic Ports for all of the IP segments except IPAll.

Whats the page count of the indexes still fragmented and what are the index types?

SELECT object_name(IPS.object_id) AS [TableName],

SI.name AS [IndexName],

IPS.Index_type_desc,

IPS.avg_fragmentation_in_percent,

IPS.avg_fragment_size_in_pages,

IPS.avg_page_space_used_in_percent,

IPS.record_count,

IPS.ghost_record_count,

IPS.fragment_count,

IPS.avg_fragment_size_in_pages

FROM sys.dm_db_index_physical_stats(db_id(N'PCSTESTDBV2_11042015'), null,...

What are you trying to display?

Care to post your logs, obfuscated of course for any critical information, the status messages should get logged

Also take a look at https://msdn.microsoft.com/en-us/library/ms365781.aspx for tips on monitoring mirroring.

select max(repdate) from @tempdat where repdate < @StartDate

There should be an entry in the SQL log when it disconnects

Remote working an option?

structure

Take a look at sys.database_mirroring specifically the mirroring state column

I can't make heads nor tails of your sample data.

Can you please take a look at the link in my signature on posting code and data for the best help,...