Database Web Apps
Enterprise Issues Business Rules
Transaction Isolation - Quiz
Error Handling Testing
Assign Use Variables
SQL Raising Errors
SQL Server Functions
Enforcing Business Rules
Creating Triggers - Exercise
Testing SQLserver Trigger
Stored Procedures - Exercise
Stored Procedure - Quiz
Accessing Remote Data
Enterprise Manager Server
Adding Remote Login
Accessing Remote Data - Exercise
Accessing remote data with a linked server
Practice adding a linked server and accessing a remote stored procedure.
This exercise is worth a total of 25 points. You will receive up to 25 points for accurately creating the Transact-SQL statement that does the following:
Adds a linked server
Executes a remote stored procedure on the linked server
Assume that you are connected to a server named Washington. First, construct a Transact-SQL statement to add Boston as a linked server to Washington. Second, write a line of code that executes a remote stored procedure, called
located on the Boston server in the Employees database, owned by
stored procedure accepts one argument, which is the ID of the employee.
In your SQL statement, pass the value of
for this parameter.
Submitting the exercise
Type or paste your Transact-SQL statement into the text box below, then click the
button to submit it and view a results page.