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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Passing DB Name as a Parameter to Stored Proc
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...- vness
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Stored Procedure to Connect to another server
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...- vness
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Stored Procedure to Connect to another 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...- vness
- Post #4
- Forum: Microsoft SQL Server: Programming
-
TOP 3 for Analysis Services to Work
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...
