Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by fredscuba

  1. fredscuba

    How to replicate changes to linked server views

    Denny, So what you are saying is that I could query the table on the linked server from inside a stored procedure, *BUT* that it still would not solve the problem of a structure change on the table that is accessed remotely? masds - You asked for a defination of my table and the view. Well, it...
  2. fredscuba

    How to shorten four-part naming convention?

    OK, that would help a little, but how do I create an alias name when setting up the linked server? I used Enterprise Manager to add the linked servers. fredscuba
  3. fredscuba

    How to replicate changes to linked server views

    You wrote "If you want something that updates **manually**, you would need to do a select t1.* from table t1 within a stored procedure. Denny Did you mean automatically? Because that is what I am looking for. How would doing a select from within a stored procedure help me? What I want is a...
  4. fredscuba

    How to shorten four-part naming convention?

    What do you mean with "You can setup the linked servers with aliases when you create them"? What form would the alias take and would that shorten the server\instance.database string? For example can I set up an alias between server1 and server2 and get an alias to shorten the...
  5. fredscuba

    How to replicate changes to linked server views

    Hi, How do I set up a view in a linked server to update automatically whenever the table that it is pointing to on the linked server changes in structure. For example, my view to a table on the linked server works fine, until the table that it is pointing to is changed, for example a new...
  6. fredscuba

    How to shorten four-part naming convention?

    That sucks!!! So you are telling me that there is no way to alias a SQL Server instance. We have multiple databases on a physical server, so to distinguish between them, our SQL Server name includes the physical (Windows) server name *and* the SQL Server name. So for instance we would have...
  7. fredscuba

    How to shorten four-part naming convention?

    I have several SQL Server linked servers set up and was wondering whether there is a way to create an alias to substitute for the four-part naming convention? So instead of having to write: select * from [server].database.tableowner.table for a query on a table that is on the linked server...
See more

Part and Inventory Search

Back
Top