Ask Question Asked 6 years, 4 ... or are you looking to connect to the database and run your query directly in C#?

You can use a linked Server, the EXECUTE (Transact-SQL) to run a stored procedure supports the "AT linked_server_name" clause to start the SP on the linked Server, see example "G. But when I run it, SM21 reports 'No shared library found for the database with ID WFS_SQL'.

To execute your command directly from within C#, you would use the SqlCommand class. I am using SQL Server 2008 Enterprise.

109. EXEC AT specifies that command_string is executed against linked_server_name and results, if any, are returned to the client. EXEC SQL PERFORMING WRITE_STATION. SET CONNECTION 'W' ENDEXEC. Searching … Within plain T-SQL you can not change the Server connection context to a different SQL Server, that's only possible in SqlCmd mode/tool. How to directly execute SQL query in C#? EXECUTE AS-Klausel (Transact-SQL) EXECUTE AS Clause (Transact-SQL) 03/14/2017; 7 Minuten Lesedauer; In diesem Artikel. To use this feature, you will need to establish a linked server connection from your local SQL Server instance to the remote SQL Server instance.

This makes me think that my MS Sql Server (2000) needs to be 'listening' for the inbound connection.

:Connect server_name[\instance_name] [-l timeout] [-U user_name [-P password] If you are connecting to multiple servers, be sure to insert GO between connections; otherwise your T-SQL won't execute on the server you're thinking it will. SQL Server 2005 introduces an enhancement to the EXEC command to allow dynamic SQL execution on the linked server. I want to see any active SQL Server connections, and the related information of all the connections, like from which IP address, connect to which database or something. SELECT STATION INTO :WA_STATION from STATIONS; ENDEXEC.

GILT FÜR: SQL Server Azure SQL-Datenbank Azure Synapse Analytics (SQL DW) Parallel Data Warehouse APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse In SQL Server SQL Server können Sie den Ausführungskontext der …

CONNECT TO 'WFS_SQL' AS 'W' ENDEXEC. EXEC SQL. The new EXEC AT command addresses the above limitations of OPENQUERY and OPENROWSET. EXEC or EXECUTE statement now supports a parameter called AT which allows you to specify the SQL Server instance at which you plan to execute your command from your local SQL Server instance.

EXEC SQL. . 0.

– Nate Feb 11 '14 at 17:56. add a comment | 3 Answers Active Oldest Votes.