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...
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...
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...
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 (..).
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???
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.