Re: Link
From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 03/29/04
- Next message: Wayne Snyder: "Re: oracle error"
- Previous message: Wayne Snyder: "Re: How to improve performance of the report's display while updating the table?"
- In reply to: Bruce de Freitas: "Link"
- Next in thread: Bruce de Freitas: "Re: Link"
- Reply: Bruce de Freitas: "Re: Link"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Mar 2004 07:14:16 -0500
Bruce,
If you create the sp on the foreign system, you would NOT have to use the
4part name in the sp.. Only use the 2-part name in the sp, and use the
4-part name to call it from your primary server.
-- Wayne Snyder, MCDBA, SQL Server MVP Computer Education Services Corporation (CESC), Charlotte, NC www.computeredservices.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Bruce de Freitas" <bruce@defreitas.com> wrote in message news:102a501c414e2$f34ab360$a001280a@phx.gbl... > Hello. Have a cross-server query that we use a NOLOCK so > nobody complains about locks on their server. ANyway, > this works ok on SQL 7, but running the exact same code on > SQL 2000 I get the error below as though you can't do a > NOLOCK now when using a Linked Server under SQL 2000?? > Any ideas on that or a better way to enure that we do as > few locks as possible on that other server we're pulling > data from??? Thanks, Bruce > > select col1, col2 FROM SERVER.DB.dbo.TABLE WITH (NOLOCK) > > Server: Msg 7377, Level 16, State 1, Procedure PROC_NAME > Cannot specify an index or locking hint for a remote data > source.
- Next message: Wayne Snyder: "Re: oracle error"
- Previous message: Wayne Snyder: "Re: How to improve performance of the report's display while updating the table?"
- In reply to: Bruce de Freitas: "Link"
- Next in thread: Bruce de Freitas: "Re: Link"
- Reply: Bruce de Freitas: "Re: Link"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
