Forum Replies Created
Viewing 15 posts - 76 through 90 (of 360 total)
-
RE: Issue with Linked server permissions
Lowell (8/14/2012)
i think only simple DML queries will work on 4 part names;you have to issue commands like that with EXECUTE.. AT for commands, SET or DBCC options.
EXECUTE ( 'set...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Issue with Linked server permissions
SQLKnowItAll (8/14/2012)
Sapen (8/14/2012)
Hi All,I am trying to set identity off over a linked server on a table. Both the servers are SQL Servers. The login is a domain admin account...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Getting errors when using linked server queries in SSIS packages
robert.gerald.taylor (8/11/2012)
Yes; linked servers are supported in SSIS. Can you manually get the SELECT to work between the servers in SSMS? If so, then we can proceed from...“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Getting errors when using linked server queries in SSIS packages
Thanks for the replies guys. I wouldnt mess with linked servers if database was a SQL Server database. The problem is sql queries wont work directly on MAS90 (providex) database....
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Linked server permissions for a sql user
There is a user I am using in the provider string for the linked server. I am using the same user which I am pretty sure should have enough permissions...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Linked server permissions for a sql user
Lowell (8/7/2012)
you said if you connect to teh server as your own user, you can select from that table via the linked server, right?that error sounds like the MAS90 user...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Linked server permissions for a sql user
Lowell (8/7/2012)
Sapen (8/7/2012)
Mine is setup the same way as shown in the image. But what permissions are you referring to? the user is a sysadmin on SQLServer but should it...“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Linked server permissions for a sql user
Lowell (8/7/2012)
you can use the current login and pass it to the other server, if they have permissions, or you can specify to use a specific user.
Mine is setup the...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: linked server error
DBA328 (7/24/2012)
Do you have permission to access table on link2mas90?One of the accounts I am trying to connect to sqlserver is the sysadmin and also a domain admin and I...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: linked server error
Sapen (7/23/2012)
SQLRNNR (7/23/2012)
Are you running SSMS as an Administrator? It may be UAC interfering and causing the errors to crop up.i have disabled uac...but it still wont work.
Error:
OLE DB...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: linked server error
SQLRNNR (7/23/2012)
Are you running SSMS as an Administrator? It may be UAC interfering and causing the errors to crop up.i have disabled uac...but it still wont work.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Linked server permissions issue
andrew.davies 84954 (7/19/2012)
did that end up being the problem? One is 32 bit and its trying to run a linked server against a 64bit version....BUT....it has no problems running other...“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Linked server permissions issue
andrew.davies 84954 (7/19/2012)
Did anyone ever figure anything out with this? Im having the exact same issue.I connect to server A running Sql and can execute my stored procedure that has...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Finding Top N worst performaing queries
The last time the server was rebooted was 3 weeks back
Currently the fragmentation is below 20% on the database. Please find attached screenshot of my top waittypes. I am still...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
-
RE: Finding Top N worst performaing queries
When I executed the query on our production database it returned multiple insert statements that were executed 633466,
3004769,
2735369, and so on number of times and I know that they are...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Viewing 15 posts - 76 through 90 (of 360 total)