# \#ssms **URL:** https://community.cdata.com/tag/ssms/221.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [SQL Server Database and User Creation For A SQL Server user with Least Privilege Acces](https://community.cdata.com/t/sql-server-database-and-user-creation-for-a-sql-server-user-with-least-privilege-acces/1305)
**Author:** [@michaeld](https://community.cdata.com/u/michaeld)\ **Replies:** 0\ **Last updated:** [June 18, 2026, 8:51pm UTC](https://community.cdata.com/t/sql-server-database-and-user-creation-for-a-sql-server-user-with-least-privilege-acces/1305 "2026-06-18T20:51:49Z")
The Following Scripts can be used to create a SQL Server Database and SQL Server user with Minimum permissions. Executive summary This design follows least privilege, clear ownership boundaries, and containment. The… --- ## [Executing a table trigger](https://community.cdata.com/t/executing-a-table-trigger/755)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [June 7, 2024, 9:41pm UTC](https://community.cdata.com/t/executing-a-table-trigger/755 "2024-06-07T21:41:22Z")
With SQL Gateway, we can expose our ODBC data sources as if they were MySQL or SQL Server databases. This allows us to create a Linked Server for any ODBC data source and work with our data as if it were a SQL Server ins… --- ## [How to Query System Tables from a Linked Server](https://community.cdata.com/t/how-to-query-system-tables-from-a-linked-server/754)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [June 7, 2024, 9:14pm UTC](https://community.cdata.com/t/how-to-query-system-tables-from-a-linked-server/754 "2024-06-07T21:14:20Z")
When you create a linked server in SSMS, the System Tables are not available in the table/view listing, but they can still be accessed and queried. To query the System Tables, you will be using the OPENQUERY call, lik… --- ## [How to Execute Stored Procedures from a Linked Server](https://community.cdata.com/t/how-to-execute-stored-procedures-from-a-linked-server/750)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [June 6, 2024, 7:46pm UTC](https://community.cdata.com/t/how-to-execute-stored-procedures-from-a-linked-server/750 "2024-06-06T19:46:42Z")
To execute Stored Procedures, you will first need to enable RPC and RPC Out in the settings for the Linked Server. You can access the settings by right clicking your created Linked Server in SSMS and going to the propert… --- ## [“Object reference” error when editing the connection string in a deployed SSAS project in SSMS](https://community.cdata.com/t/object-reference-error-when-editing-the-connection-string-in-a-deployed-ssas-project-in-ssms/647)
**Author:** [@John\_G](https://community.cdata.com/u/John_G)\ **Replies:** 0\ **Last updated:** [March 1, 2024, 2:23pm UTC](https://community.cdata.com/t/object-reference-error-when-editing-the-connection-string-in-a-deployed-ssas-project-in-ssms/647 "2024-03-01T14:23:34Z")
When attempting to change the connection settings on a deployed SQL Server Analysis Services (SSAS) package in SQL Server Management Studio (SSMS), you may see an “Object reference not set to an instance of an object” er… --- ## [Linked Server: Physical connection is not usable \[xFFFFFFFF\] error](https://community.cdata.com/t/linked-server-physical-connection-is-not-usable-xffffffff-error/409)
**Author:** [@Kristian\_K](https://community.cdata.com/u/Kristian_K)\ **Replies:** 0\ **Last updated:** [September 21, 2023, 6:33pm UTC](https://community.cdata.com/t/linked-server-physical-connection-is-not-usable-xffffffff-error/409 "2023-09-21T18:33:46Z")
The problem typically arises when there is a discrepancy between the DSN name used and the Catalog value when setting up a linked server. The value should correspond with the DSN employed by the SQL Gateway Service. I… --- ## [Cannot process the object ""CatalogName"."SchemaName"."TableName"". The OLE DB provider "SQLNCLI11" for linked server "ConnectionName" indicates that either the object has no columns or the current user does not have permissions on that object](https://community.cdata.com/t/cannot-process-the-object-catalogname-schemaname-tablename-the-ole-db-provider-sqlncli11-for-linked-server-connectionname-indicates-that-either-the-object-has-no-columns-or-the-current-user-does-not-have-permissions-on-that-object/323)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 8, 2023, 9:53pm UTC](https://community.cdata.com/t/cannot-process-the-object-catalogname-schemaname-tablename-the-ole-db-provider-sqlncli11-for-linked-server-connectionname-indicates-that-either-the-object-has-no-columns-or-the-current-user-does-not-have-permissions-on-that-object/323 "2023-08-08T21:53:18Z")
This error comes from the SQL Server, which indicates there are no permissions to read this table. We can try to use an OPENQUERY to work around these limitations. SELECT \* FROM OPENQUERY (‘ACUMATICA REST’, ‘SELECT \* … --- ## [Cannot select more than 4096 columns in the SELECT statement error](https://community.cdata.com/t/cannot-select-more-than-4096-columns-in-the-select-statement-error/322)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 8, 2023, 6:21pm UTC](https://community.cdata.com/t/cannot-select-more-than-4096-columns-in-the-select-statement-error/322 "2023-08-08T18:21:38Z")
This is an SQL Server limitation, you can see more about that in the link below: Maximum capacity specifications for SQL Server - SQL Server | Microsoft Learn Even though you cannot select more than 4096 columns, you … --- ## [Linked Server: Joins in OpenQuery fail](https://community.cdata.com/t/linked-server-joins-in-openquery-fail/317)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 7, 2023, 6:13pm UTC](https://community.cdata.com/t/linked-server-joins-in-openquery-fail/317 "2023-08-07T18:13:33Z")
Using OpenQuery throws the “Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name “id” is a duplicate.” error. This error occurs with every JOIN. The tests I ma… --- ## [SQL Gateway does not support multiple schemas](https://community.cdata.com/t/sql-gateway-does-not-support-multiple-schemas/311)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 3, 2023, 5:47pm UTC](https://community.cdata.com/t/sql-gateway-does-not-support-multiple-schemas/311 "2023-08-03T17:47:14Z")
SQL Gateway does not allow you to select different schemas at once. Depending on the driver, in order to access different schemas, the main workaround is to create different Data Sources and Linked Servers. Based on the … --- ## [UPSERT is not supported in SQL Server Management Studio](https://community.cdata.com/t/upsert-is-not-supported-in-sql-server-management-studio/308)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 2, 2023, 8:21pm UTC](https://community.cdata.com/t/upsert-is-not-supported-in-sql-server-management-studio/308 "2023-08-02T20:21:51Z")
Unfortunately, this issue has nothing to do with the CData ODBC driver itself, as our tool supports UPSERTS wherever applicable. The problem here is that SQL Server Management Studio itself does not support upsert operat… --- ## [Error message code 500: Could not execute the specified command: Unknown datatype: unique identifier.](https://community.cdata.com/t/error-message-code-500-could-not-execute-the-specified-command-unknown-datatype-unique-identifier/307)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [August 2, 2023, 6:05pm UTC](https://community.cdata.com/t/error-message-code-500-could-not-execute-the-specified-command-unknown-datatype-unique-identifier/307 "2023-08-02T18:05:43Z")
Example scenario: declare @id uniqueidentifier = ‘123’ SELECT AccountId FROM \[CData\].\[dbo\].\[Test\] a WHERE a.AccountId = @id The driver is avoiding this process since the conversion is not supported in SQL …