Is it possible to pass a database name into a stored procedure as variable to fully qualify an object?
For example:
CREATE PROCEDURE [dbo].[Test_SP]
@p2 as nvarchar(10)
AS
SELECT DISTINCT @p2.dbo.Objects.Col1, @p2.dbo.Objects.Col3, @p2.dbo.Objects.Col4, @p2.dbo.Objects.ID
FROM...
1) Are both servers running SQL Server? - YES
2) What version of SQL server are you running? SQL 2K SP2
3) Is the Same version installed on both servers? YES
4) On which server are you trying to run the update? on the linked server - Server 2
5) Have you created the linked server on that server...
One of my programmers is trying to extract data from tables in the Server1.DBX database into a temp table and use it to update the "tblname" table in the Server2\DB1 database.
I have tried changing the linked server as you suggested
update LinkedServer.dbo.TableName
set FieldName1...
I am the dba and my programmers wanted to use Analysis Services. I have never used it before but I had to make it work. After beating my head in, here are the top three things that got it to work for me.
Our environment:
Users have NT authenticated IDs
Database Server - SQL Server 2000 SP2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.