Not even a Shared lock, huh?

Sounds like maybe a good job for Snapshot Replication...

http://technet.microsoft.com/en-us/library/ms151832.aspx

If you want to do it programmatically have a look at:

sp_posttracertoken

http://technet.microsoft.com/en-us/library/ms176091.aspx

and

sp_helptracertokenhistory

http://technet.microsoft.com/en-us/library/ms187349.aspx

A bit more reading here: http://technet.microsoft.com/en-us/library/ms147309(v=sql.105).aspx

Otherwise, you can always insert a tracer in Replication Monitor> Select the Publication>...

Hi Jason,

I've done a fair bit of tinkering with Availability Groups, mostly from the Virtual Labs at:

http://www.microsoft.com/en-us/sqlserver/learning-center/virtual-labs.aspx

I think what you are proposing is possible, although I haven't tried it... seems...

Furthermore, a great feature...

When a change to and Audit or Audit Specification are attempted, the Audit or Audit Specification must be DISABLED to make that change.

That DISABLE and ENABLE (after...

I realize this is an old post, but ran across it working on a SQL Audit issue myself

For any future reference:

Look for the Server-Level Audit Action Group - AUDIT_CHANGE_GROUP

This...

Thank you for posting! Books Online says this in ALTER ENDPOINT:

AUTHORIZATION login

The AUTHORIZATION option is not available in ALTER ENDPOINT. Ownership can only be assigned when the endpoint is...

Indeed, looks to me like the path 'G:\MFE_PROFOS DATA\GroheUPI.mdf' is not valid... or SQL cannot see it.

Is the G drive visible from SQL?

Try exec xp_fixeddrives

If the disk isn't...

Maybe check the Network Protocol selection under Connection Properites Tab in the New Server Registration window.

Also, check SQL Server Configuration Manager locally for Native Client> Client Protocols> is TCP/IP enabled?

What is the version of SQL Server Management Studio you are using?

What is the version of SQL Server of the instance you are connecting to?

Or tell your server admins that it just needs permissions to send an email...

seems like a reasonable enough request.

Maybe investigate Database Mail functionality... keep it all within SQL then?

Super curious now... what is he trying to accomplish with an ActiveX script?

Hopefully something external of SQL Server!

Ok makes sense... developer as SQL authentication. All those rights are within you're control.

However, regarding what permissions the Credential (Windows Account you will use to actually execute the ActiveX)......

Ah, almost forgot... no sysadmin needed.

Give minimum permissions required to the developer login, and the Credential that will be used by the Proxy.

NO SYSAMIN TO ANYONE EVER!

Except for...