Hi Robert,

I just sent you an email. "Wed 12/10/2014 11:14 AM"

Thanks much

That's why I am getting a proccess in place to get objects pushed to prod.

I still do not want any of the devs creating indexes. I have seen on a...

They don't have DDL_Admin in prod, only dev.

The ETL developers push through any changes with a proxy account and to date, none of the indexes were checked.

They can do pretty...

We purchased Idera Compliance Manager and found out that it will only track data if it is NOT in a view or SP. Since my company only has views set...

Auditing would be much easier to set up, but way less secure.

"Even when the Database Engine is writing to a file, other Windows users can read the audit file if...

Perfect! Works like a charm. Now I can track the members of my group.

Thanks

OPENROWSET (Transact-SQL)

SELECT a.*

FROM OPENROWSET('SQLNCLI', 'Server=Seattle1;Trusted_Connection=yes;',

'SELECT GroupName, Name, DepartmentID

FROM AdventureWorks2012.HumanResources.Department

ORDER BY GroupName, Name') AS...

One last thing to think about.

ServerName DatabaseName

sa dbo

Domain\User\Domain\User

SELECT a.name AS...

Today when I ran SELECT * FROM sys.database_principals the '\' was gone from the front of the login and this time the sp_dropuser 'domanin\user' did work.

I was able to add...

Jared,

Exactly!!

A friend (MS SQL guy) said to open a trouble ticket with MSFT because it is very weird and most defiantly shouldn't be happening.

The really bad part is one person...

Nope, not at all.

I took over as DBA a wile ago and the security was not quite what it should be. I've been fixing ever since.

Another weird thing that is...

I have other user accounts on some servers that do not have domain accounts and these accounts cannot be deleted either.

I have tried all the tricks listed in these blogs...

I have tried to drop the account and it will not do it.

Sort of had the same idea. I will back up the one dB that is giving me issues, drop it, and restore it.

I'll do it tonight and post back if...

Jared,

I have tried to run that fix in the dB, but it didn't work.

I also ran this

SELECT a.name AS 'Server Name'

, a.sid AS 'Server ID'

, b.name AS 'Database Name'

, b.sid...