It's called SQL Database at the moment which is part of...

Mac1986 (12/28/2012)

---

Hi all.

Appreciate your support here.

This is resoled now. I created a new linked server for the same server now with alias.

now I kicked off the job remotely and...

I think I may have exhausted all the tests I can muster locally or with you. I am not having trouble with a Linked Server setup the same way as...

hakim.ali (12/28/2012)

---

Thanks for shedding the light, and good points. However, given that these scenarios are probably the exceptions rather than the norm, why not default to all tables being clustered,...

CELKO (12/28/2012)

---

Usually I have to identify a person by the role they play in the Universe of Discourse. Most often the role does actually involve a person; a bank account...

Something sounds off...you cannot explicitly ask SQL Server to listen on TCP 1434 as that is the port designated for use by the Dedicated Admin Connection. You can connect to...

Cool. It won't be right away, but hopefully sometime over the weekend.

Mac1986 (12/28/2012)

---

thanks . Below is the result when i ran it remotely using linked server.

EXEC('SELECT ORIGINAL_LOGIN() as logged_in_login;') AT [LocalServerName];

Result: REDMOND\Mycredential

EXEC('SELECT * FROM msdb.dbo.sysjobs WHERE name = ''22274680-BFBF-4191-913E-40491393C490'';') AT [TK5BITOOLSVM01]:

This...

@rcjunk

Did the Workaround from the article MOC Ewoz posted work for you?

hakim.ali (12/28/2012)

---

If it were an index, then why would the database scan every record in a heap when you were searching...

What have you tried so far?

Attach the Excel sheet to this thread and I'll have a look.

Why locally on the server where the job is hosted? That does not prove anything.

Please run the code I posted on the remote server where [ServerName] is the name of...

I had this issue many many times on SQL 2005 SP4 running...

Is this an Excel VBA question or an SSIS question? Or something else?