(Msg. 1) Posted: Mon Jul 14, 2008 3:36 pm
Post subject: SQL Server View on two Database Server question Archived from groups: microsoft>public>sqlserver>programming (more info?)
Hi,
In my SQL Server 2000, I would like to create a VIEW across two databases on
two database servers.
How do I do that?
Thanks for help.
(Msg. 2) Posted: Mon Jul 14, 2008 3:36 pm
Post subject: RE: SQL Server View on two Database Server question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You can use linked servers and then simply use four-part names for objects
referenced in the view.
ASP+Different Server(2 SQL Server installed in different P.. - Dear all: I have a problem about ASP link with 2 different SQL Server. (2 SQL server installed in 2 different PCs) I have few tables stored in Server A. (The source) and for some reason I create few tables in Server B. I am tring to use ASP to select..
Database Server Name within SQL Server Management Studio - Is there any way to discern which table belongs to which server when I open a table within SQL Server Management Studio??? Some clarification...if I open a DEV Table, I'd like the tab within SQL Server Management Studio to disclose the server in which...
View SQLServer Linked Server Processes - Hi, Is there a way I can view SQLServer processing steps while it is connecting to a linked server? I'm trying to track down a problem of sporadically not connecting to Linked Server to Access mdb. Thanks. Alan.
Login failed for user 'NT AUTHORITYSYSTEM'. [CLIENT: 192.1.. - It's been suggested that I post here rather than in the windows.server.sbs WIN2003SBS Premium R2 Help! This error is appearing every one minute when SQL Server and SQL Server Agent are running (but not when not): Event Type: Failure Audit Event..
10,000 Feet View - SQL Server 2005 Security - Does anyone know of a hierachical chart which shows at a glance how the securables on a SQL Server 2005 database can be affected. I guess what I am trying to say for example, for server roles, database roles, permissions granted on schemas, and object...
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
