Error 262 SHOWPLAN permission denied in database when …
Dec 5, 2011 · Some of these objects are server-level objects others are database-level objects. Some of the database objects are schema-bound, for instances tables, views, stored …
TDE vs Row\Cell\Column Encryption - social.msdn.microsoft.com
Nov 15, 2011 · However, the ciphertext in cell level encryption requires the varbinary data type in SQL Server. That means you have to modify your schema. It also means your indexes, keys …
SSMS permissions vs Db permissions - social.msdn.microsoft.com
Sep 23, 2009 · Above provides 'FinDevUser' query access as I expected but they cannot view the 'fin' schema tables in 'FinanceDev' Db in SSMS ( SQL Server Management Studio ), although …
ODBC Issue on SQL Server 2017 - social.msdn.microsoft.com
May 26, 2018 · We recently upgraded to SQL Server 2017 to utilize in-database Advanced Analytics. However, when I connect to SQL Server database via ODBC or via R and Python …
Cannot Deploy SQL Server Database to Azure SQL
Dec 19, 2017 · To test the Azure SQL Server, I created a database and added a table and connected to it through SSMS and a Microsoft Access ODBC Connection. I am using SQL …
One-part name VS two-part name - social.msdn.microsoft.com
Nov 8, 2017 · If you use one-part names, the second part, the schema, will be taken from the default. Which for an ad-hoc batch is the default schema for the current user, but for a stored …
stored procedure for rebuild indexes - social.msdn.microsoft.com
Oct 11, 2012 · Question 0 Sign in to vote hi all this is my rebuild index query, i schedule it in sql server agent (jobs),but it getting failed my stored procedure here :
SSAS Tabular Model DMV : All Catalog last refresh and schema …
Nov 20, 2017 · If I want to list out all the catalogs Schema related info like Last Process Date, Last Schema update data of SSAS Tabular cubes using below DMV's by joining them , is it …
How to Grant grant user rights to select from catalog views??
Jul 18, 2008 · SQL 2005 W2K3. I've created a stored procedure that selects from the SYS.databases, SYS.database_principals, and SYS.database_role_members catalog views. I …
sp_register_custom_scripting help needed
Oct 5, 2010 · I have a SQL 2008 server in a data center. I have a table that has bi-directional transactional replication set up on it to/from several remote sites. Replication TO & FROM the …