Lowell (8/14/2012)

---

i think only simple DML queries will work on 4 part names;

you have to issue commands like that with EXECUTE.. AT for commands, SET or DBCC options.

EXECUTE ( 'set...

SQLKnowItAll (8/14/2012)

---

Sapen (8/14/2012)

---

Hi All,

I am trying to set identity off over a linked server on a table. Both the servers are SQL Servers. The login is a domain admin account...

robert.gerald.taylor (8/11/2012)

---

Yes; linked servers are supported in SSIS. Can you manually get the SELECT to work between the servers in SSMS? If so, then we can proceed from...

Thanks for the replies guys. I wouldnt mess with linked servers if database was a SQL Server database. The problem is sql queries wont work directly on MAS90 (providex) database....

There is a user I am using in the provider string for the linked server. I am using the same user which I am pretty sure should have enough permissions...

Lowell (8/7/2012)

---

you said if you connect to teh server as your own user, you can select from that table via the linked server, right?

that error sounds like the MAS90 user...

Lowell (8/7/2012)

---

Sapen (8/7/2012)

---

Mine is setup the same way as shown in the image. But what permissions are you referring to? the user is a sysadmin on SQLServer but should it...

Mine is setup the...

One of the accounts I am trying to connect to sqlserver is the sysadmin and also a domain admin and I...

Error:

OLE DB...

i have disabled uac...but it still wont work.

andrew.davies 84954 (7/19/2012)

---

did that end up being the problem? One is 32 bit and its trying to run a linked server against a 64bit version....BUT....it has no problems running other...

andrew.davies 84954 (7/19/2012)

---

Did anyone ever figure anything out with this? Im having the exact same issue.

I connect to server A running Sql and can execute my stored procedure that has...

The last time the server was rebooted was 3 weeks back

Currently the fragmentation is below 20% on the database. Please find attached screenshot of my top waittypes. I am still...

When I executed the query on our production database it returned multiple insert statements that were executed 633466,

3004769,

2735369, and so on number of times and I know that they are...