-
as seen on Server Fault
- Search for 'Server Fault'
I don't have access to the Active Directory settings, nor do I have access to change anything on the linked server.
From everything I've read, it seems like this means I cannot use Kerberos - which is a big problem, because I don't know how to use a linked server without it.
Is there any way to…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
I need to create a linked server with SQL Server Management Studio 2005 to an Access 95 database, which happens to be password protected at the database level. User level security has not been implemented.
I cannot convert the Access database to a newer version. It is being used by a 3rd party…
>>> More
-
as seen on SQL Team
- Search for 'SQL Team'
I did another SQL Server migration over the weekend that dealt with linked servers. I’ve seen all kinds of odd naming schemes and there are a few I like and a few I suggest you avoid. Don’t name your linked server for its IP address. At some point whatever is on the other end of that IP address…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
After much fiddling, I've managed to install the right ODBC driver and have successfully created a linked server on SQL Server 2008, by which I can access my PostgreSQL db from SQL server.
I'm copying all of the data from some of the tables in the PgSQL DB into SQL Server using merge statements…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
I have a table called Table with columns:
ID (int, primary key, clustered, unique index)
TEXT (varchar 15)
on a MSSQL linked server called LS. Linked server is on the same server computer. And:
When I call:
SELECT ID, TEXT FROM OPENQUERY(LS, 'SELECT ID, TEXT FROM Table')
It takes…
>>> More
