thank you for all the information. It has been very helpful.

Great. thank you. That seemed to work

I figured it out. There was not a space in between quotes so it wouldn't wrap on the server

Okay. That makes sense.

thanks for your help.

I must be missing something. So using your example what is going to happen if I create an index on table customer, with Fields Joindate, Name, surname, phone

with...

Okay. I understand that. What is the performance benefit of ordering versus non ordering the columns. If I have an index that has one column and 3 included columns....

the other thing I have noticed is if I explicitly set the parameters in the stored proc to a value and then execute the stored procedure it will run pretty...

Via SSMS. The isolation levels are set to SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

They are in the same domain. And I am logging in as a windows user. I will have to wait to try putting in as a user until...

For a login not defined in the list above, connections will:

Be Made using the login's current security context

yes. I am able to run queries on it. I can run the query in the opposite direction. Meaning I can go to the opposite server from...

Here is the script I used for the Linked Server. The linked server has been there for a long time. It is just this database that is not...

I have full administrative rights on the Linked server as well. And I am the one running the query. Am I missing something in what other user needs permission?

Here is a copy of the function. I did try using a 0 but that didn't work. It is looking at the sections before and after the - so...

Yes. I am trying to back up to a different sql server. I have a domain account running services and that same domain account has permissions to the...