@kaptan - please do not think we are "bashing" your question by voting-to-close it. Prior to the question being closed, we provided several answers; all where turned down with "that doesn't work", with no reason why they wouldn't work. Since you have added a fair explanation of why those answers won't work, I will vote-to-reopen your question, in the hopes you may find an answer that will work. — Max Vernon14 secs ago
With the caveat that I'm not a security person...
There is no predefined database role other than ssis_admin that is special to the SSISDB. That allows one to do all the SSIS things but that's clearly more power than a support person should have.
There are two schemas, internal and catalog. Cat...
@MaxVernon from where i am looking at the question, i believe the question is clear enough. the question is well stated along with the limitations and conditions. the reasons why such limitations and conditions exist are irrelevant to any potential answer. — kaptan2 hours ago
How suprising that you understand your dumb question quite clearly.
I have the following set-up:
SQL-Server 1 --linked--> SQL-Server 2 --linked-> SQL-Server 3
The question is can I query SQL Server 3 from SQL Server 1 via SQL Server 2?
I have unfortunately several restrictions:
cannot use openquery
cannot use views on Server 2 (there would be many of th...
Unfortunately, with the conditions you've placed on your question, there is no way to accomplish what you want.
SQL Server would need to support 5 part naming such as:
SELECT *
FROM server1.server2.database.schema.table;
Which is clearly not going to work.
> “It’s a long, uphill fight to get back to original orthodoxy. We have two ‘originalists’ on the Supreme Court,” Scalia said, referring to Thomas. “That’s something. But I feel like Frodo … We’ll get clobbered in the end, but it’s worth it.”
and ultimately you fail at the task you set out to do and the only reason your task gets completed is some nut job bites your finger off and falls into lava
SET @SQL='SELECT ROW_NUMBER() OVER
(ORDER BY ' + @SortColumn+ ' ' + @SortDirection + ') RowNum, ' + @PrimaryKey + ', ' + @Columns + '
INTO tempTableName
FROM ' + @TableName + ' Where 1 = 1 ' + @WhereCondition
With the caveat that I'm not a security person...
There is no predefined database role other than ssis_admin that is special to the SSISDB. That allows one to do all the SSIS things but that's clearly more power than a support person should have.
There are two schemas, internal and catalog. Cat...
I have the following set-up:
SQL-Server 1 --linked--> SQL-Server 2 --linked-> SQL-Server 3
The question is can I query SQL Server 3 from SQL Server 1 via SQL Server 2?
I have unfortunately several restrictions:
cannot use openquery
cannot use views on Server 2 (there would be many of th...
Unfortunately, with the conditions you've placed on your question, there is no way to accomplish what you want.
SQL Server would need to support 5 part naming such as:
SELECT *
FROM server1.server2.database.schema.table;
Which is clearly not going to work.
