Found the reason.  Hope they address this soon...

https://social.msdn.microsoft.com/Forums/Windows/en-US/3e89dfb5-b2d7-45a5-b2f8-1e8527498118/error-for-json-path-fails-when-parsing-an-ampersand-?forum=sqltools

Honestly, this would have very little to do with SQL Server.

Roles and Authorization for web applications are usually managed by the code of the application itself.

You could leverage...

It is erroneous to assume that all roles other than sysadmin and db_owner are mutually exclusive.

As far as why this redundancy is allowed, my guess it that it's easier and...

You can also do...

GRANT VIEW DEFINITION ON SCHEMA::[SchemaName] TO [User/Role];

-- or

GRANT EXECUTE ON SCHEMA::[SchemaName] TO [User/Role];

Maybe it's overkill, but I would probably write your query like this...

As far as indexing goes, my first inclination is to drop index [tblrecord].[idx_Followupdate] and replace it with 2 new...

How I actually solved this for now is:

CREATE PROCEDURE dbo.usp_CreateSnapshot_ExecAs

AS

BEGIN

EXECUTE AS LOGIN = 'ProxyTest';

CREATE DATABASE MY_SNAPSHOT

ON

(Name = 'MyDBData', Filename = 'E:\MSSQL.3\DATA\MY_SNAPSHOT_MyDB_1.SNAP'),

(Name = 'MyDBData2', Filename = 'E:\MSSQL.3\DATA\MY_SNAPSHOT_MyDB_1_2.SNAP'),

(Name = 'MyDBData3', Filename =...

Hello all,

I found the source of my problem, which also describes why this setup worked for us in DEV, but not TST.

Long story short, the [master] database was set to...

Has anybody seen this before?

Does anyone have any other suggestions for locking down the stored procedure without using EXECUTE AS?

Here is a script that I wrote for repairing schema ownerships before making bulk security changes. It saves lots of time and avoids having to do this manually. ...

Here is a CTE query I use with SSRS to get the same type information. It works perfectly. Just adjust it for your needs.

;WITH ReportUsageCounts AS

(

SELECT ...