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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vness
  • Content: Threads
  • Order by date
  1. vness

    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...
  2. vness

    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...

Part and Inventory Search

Back
Top