Nov 18, 2025 · The EXEC or EXECUTE statement can be used to send pass-through commands to linked servers. Additionally, the context in which a string or command is executed can be explicitly set.

Nov 18, 2025 · Executes a Transact-SQL statement or batch that can be reused many times, or one that is built dynamically. The Transact-SQL statement or batch can contain embedded parameters.

Nov 18, 2025 · This article describes how to execute a stored procedure in SQL Server by using SQL Server Management Studio or Transact-SQL. There are different ways to execute a stored procedure.

Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.

Dec 17, 2024 · When an EXECUTE AS statement is run, the execution context of the session is switched to the specified login or user name. After the context switch, permissions are checked …

Jun 23, 2025 · In Management Studio, using the master database, execute the following Transact-SQL statement to give specific non- sysadmin users the ability to execute xp_cmdshell.

Nov 18, 2025 · Learn how to use sqlcmd to run a Transact-SQL script file. It can contain Transact-SQL statements, sqlcmd commands, and scripting variables.

Nov 18, 2025 · For ad hoc queries, the SQL handles are hash values based on the SQL text being submitted to the server, and can originate from any database. For database objects such as stored …

Jun 23, 2025 · You can grant EXECUTE permissions on this procedure, but these permissions might be overridden during a SQL Server upgrade. Other users must be granted one of the following SQL …

Oct 17, 2024 · This section describes how to use a parameterized SQL statement in the Execute SQL task and create mappings between variables and the parameters in the SQL statement.