SatishAyyar (12/28/2012)

---

I was able to load the data as it is in EXCEL. All the columns are loaded. I do not see any issue. I have sql server 2008 R2...

cphite (12/28/2012)

---

We currently have two production servers at my company, let's call them DB1 and DB2, each with a handful of databases that are used fairly extensively throughout the day....

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...