<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
Linked Server
Items 1 to 20 of 25
Next 20 >>
Show all Objects used by Linked Server
Stored Procedure will list all objects, object type, and linked server name. The stored procedure can either be passed in a linked server name as string or null.
Read more...
By
KILEY MILAKOVIC
2012/09/17
|
Source:
SQLServerCentral.com
|
Category:
linked server
Rating:
|
Discuss
|
Briefcase
|
772 reads
Check connect to all linkeds
This script checks all links on the server
Read more...
By
Dmitriy Ivanov
2012/07/05
|
Source:
SQLServerCentral.com
|
Category:
it is launched as is.
Rating:
|
Discuss
|
Briefcase
|
755 reads
Select, Update, Delete, Insert etc.. in many servers using 1 query
Query Servers using 1 sql statement. Will make your job easy!!!
Read more...
By
Lester Policarpio
2012/03/28
|
Source:
SQLServerCentral.com
|
Category:
linked server
Rating:
|
Discuss
|
Briefcase
|
3,241 reads
Monitor Any Linked Server From SQL 2005
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005
Read more...
By
Sakthivel Chidambaram
2011/12/19
|
Source:
SQLServerCentral.com
|
Category:
monitoring
Rating:
|
Discuss
|
Briefcase
|
2,965 reads
A brief explanation and solution for the Double Hop problem
What on earth does “Login failed for user ‘(null)’, Reason: Not associated with a trusted SQL Server conn” mean?
Read more...
By
Kenneth Fisher
2011/12/09
|
Source:
SQLServerCentral.com
|
Category:
double hop
Rating:
|
Discuss
|
Briefcase
|
8,804 reads
How to Test Connectivity for a Linked Server
Just one way of testing for a linked server based on data within your database.
Read more...
By
Chris Morton
2011/09/16
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,509 reads
Exec on Linked Server
Read more...
By
Sudhir Chawla
2010/01/14
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,587 reads
Synchronize several stored procedure between two servers
Synchronize source code between two servers for multiple stored procedures
Read more...
By
Th Tr
2009/12/21
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,099 reads
Get Linked Server Configuration
This query will return the linked servers configuration
Read more...
By
mobasha B
2009/12/17
|
Source:
SQLServerCentral.com
|
Category:
linked server
Rating:
|
Discuss
|
Briefcase
|
1,603 reads
Synchronize all stored procedures between two servers
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
Read more...
By
Th Tr
2009/12/15
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,001 reads
Synchronize a stored procedure between two servers
Use this stored procedure to synchronize source code of a stored procedure between two servers.
Read more...
By
Th Tr
2009/12/11
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,495 reads
On demand creation and destruction of a Linked Server for SQL Server
Create a linked server on the fly in this tip.
Read more...
By
Additional Articles
2009/10/06
|
Source:
MSSQLTips.com
|
Category:
linked server
Rating:
Rate this
|
Briefcase
|
3,058 reads
Extract Objects of a Linked Server
In a scenario where we need to find out all the objects of a LINKED Server and check which object is accessible to us, we need to write following query:
Read more...
By
Sudhir Chawla
2009/08/07
|
Source:
SQLServerCentral.com
|
Category:
linked server
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
614 reads
Sybase linked server in sql 2005
How to create and configure Sybase linked server in SQL Server 2005
Read more...
By
umar iqbal
2009/07/21
|
Source:
SQLServerCentral.com
|
Category:
linked server
Rating:
|
Discuss
|
Briefcase
|
610 reads
Monitoring group of Linked Sql Servers from a Sql Server
The main purpose of article is to understand how to monitor group of Linked Sql Servers from a Sql Server.
Read more...
By
Additional Articles
2009/07/08
|
Source:
CodeProject.com
|
Category:
monitoring
Rating:
Rate this
|
Briefcase
|
1,877 reads
Creating a Linked Server - SQL School Video
Linked Servers allow SQL Server to access data on other systems, SQL Server, Oracle, Access, Excel, and others. MVP Andy Warren shows how to set one up in this SQL School video.
Read more...
By
Andy Warren
2009/04/07
|
Source:
JumpStartTV
|
Category:
video
Rating:
|
Discuss
|
Briefcase
|
5,692 reads
Connecting Oracle BI Publisher to SQL Server
One of the main features of Oracle Business Intelligence Publisher (BIP) is its ability to connect to pretty much every major RDBMS on the market. Steve Callan shares the little documented steps of how to establish a connection to SQL Server.
Read more...
By
Additional Articles
2009/03/30
|
Source:
Database Journal
|
Category:
business intelligence
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,478 reads
Linked Server Dependencies
This Proc is written for either SQL 2000 or SQL 2005 to return a list of objects that are dependent on Linked Servers. This proc checks all Databases and Objects on a Server.
Read more...
By
Andrew Miller-489894
2008/10/15
|
Source:
SQLServerCentral.com
|
Category:
linked server
Rating:
|
Discuss
|
Briefcase
|
1,446 reads
Reporting Services: Read Data from SSAS and SQL Server in One Dataset
Retrieve data from different data sources such as Analysis Services and SQL Server relational database as one dataset, so that you can create tables, matrices of that data.
Read more...
By
Martin Cremer
2008/09/17
|
Source:
SQLServerCentral.com
|
Category:
linked server
Rating:
|
Discuss
|
Briefcase
|
7,826 reads
Get Linked Server Configuration
This query will return the linked servers configuration
Read more...
By
mobasha B
2009/12/17
|
Source:
SQLServerCentral.com
|
Category:
linked server
Rating:
|
Discuss
|
Briefcase
|
1,603 reads
Items 1 to 20 of 25
Next 20 >>
Tags
t-sql
(4)
monitoring
(3)
stored procedures
(3)
sql server 2005
(2)
analysis services (ssas)
(1)
business intelligence
(1)
chris morton
(1)
codrakon
(1)
dependencies
(1)
double hop
(1)
it is launched as is.
(1)
it is possible to execute as regular job.
(1)
linked server sql objects
(1)
matrix
(1)
miscellaneous
(1)
oracle
(1)
performance tuning
(1)
reporting services (ssrs)
(1)
sql server 7
(1)
sybase linked server
(1)
video
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
