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 Rhinorhino 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 CodeJunkee

  1. CodeJunkee

    Can't Install AdventureWorks

    Well, I think I found the solution. There was MSSQL Instance of the machine from and MSDE install for the Veritas Backup program. I uninstalled MSSQL 2005, turned off all the MSSQL services, and Veritas Backup Services, and reinstalled SQL 2005. I also, gave in a Custom Instance name instead...
  2. CodeJunkee

    Can't Install AdventureWorks

    I have queried sys.databases and it is not there. I have tried both the installs from the setup and the downloaded .msi files. Neither automatically attach the dbs. I ran attach from the Server Management Studio and it produces the errors I reported above. I later installed the older Pubs...
  3. CodeJunkee

    Can't Install AdventureWorks

    I have just installed SQL 2005 and it is up and running but I can't get the AdventureWorks DB to install. I have tried the Setup Install, uninstall, Re-install, uninstall, and install from downloaded .msi versions. All produce the same results. The DB does not appear in the list of DBs in the...
  4. CodeJunkee

    Stored Procedure in another DB

    Thanks. That did it. I knew it was something simple. I guess I don't go cross db very much. I tried with one dot and didn't work. Forgot I needed two (..).
  5. CodeJunkee

    Stored Procedure in another DB

    I am not a big SP expert. I need to do either: 1) Access a table from another db from inside a sp, that is not in the current db 2) Access an sp from another db from the current db I couldn't find a way to do either???

Part and Inventory Search

Back
Top