Hello
I have two SQL 2005 servers, one which runs all of our database applications and is entirely my responsibility, the other which runs the back-end databases for our CTI systems and which is the responsibility of our CTI provider.
It has recently been identified that there are a number of queries being run against the CTI databases that are taking longer than 20 seconds to complete. The link between the two servers has been configured so that if the user isn't explicitly named in the Linked Server properties, a default user is used.
I need to try and set up all of my scheduled tasks so that they all run under an account that I have specified, so that I can grant explicit rights on the linked server properties. However, I can't see a way of specifying the user credentials that should be used.
Can anyone help me?
Featured
Writing your app was the hard part, but it’s not the last part. You still need to sell your app. Here's how to make sure your description puts your app in the best light. |
|
Reply With Quote
Originally Posted by ianbhenderson73
