Well... You should start here:

sp_configure 'show advanced options', 1;

RECONFIGURE;

sp_configure 'Ad Hoc Distributed Queries', 1;

RECONFIGURE;

GO

Jared

p-nut (12/1/2011)

---

I ask again, only because I cannot figure this out... Are you using the same SQL Server (windows auth) user to log into the database instance between the server...

What are you looking for? If it is not being used, how do you compare? Can you give some more information please?

Thanks,

Jared

I ask again, only because I cannot figure this out... Are you using the same SQL Server (windows auth) user to log into the database instance between the server and...

p-nut (12/1/2011)

---

I think it is this...

I think it is this setting:

SELECT...

Sapen (12/1/2011)

---

MyDoggieJessie/Jared...Thanks for your inputs...but this is still an issue...I am doing my research to figure out how to make it work...please let me know incase if you come up...

Well... This is very strange indeed, but probably has some sort of explanation. Is it possible that some other query or sp was deleting rows or putting a lock...

You are very welcome 🙂 Good luck to you!

Jared

Not sure... but it may...

Sapen (11/30/2011)

---

I had...

Sapen (11/30/2011)

---

Randy Doub (11/30/2011)

In your linked server script you have @provstr=N'DSN=SOTAMAS90'

Is this a DSN that lives on the DB server?

And when you use your laptop, that DSN can't be...

Randy Doub (11/30/2011)

---

In your linked server script you have @provstr=N'DSN=SOTAMAS90'

Is this a DSN that lives on the DB server?

And when you use your laptop, that DSN can't...

Run this: SELECT name, value FROM sys.configurations

WHERE name = 'remote access';

Is the value 1?

Jared

If you have the ability, I would consolidate all of these into 1 database with...