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 strongm 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: *

  1. administratorx

    copy database to same server with new name

    After backing up the database, you may also right click on 'Databases'and then select 'All tasks' and then restore database. Make sure to enter the name that you want the database to be known as and then select your location where the backup is located. This will then make your database with the...
  2. administratorx

    Can't Detach Database

    Make sure that it is not in use by the application. Administratorx
  3. administratorx

    What does the 'GO' command do???

    OSQL, ISQL and query analyzer all use it to signal the end of a batch. But it is not a TSQL command.
  4. administratorx

    Copying database to another server

    I would suggest that you do the backup and restore. Also make sure if you use the detach and reattach that you copy to compatible servers !!! Some people out there don't think about that. There is also a bunch of tricks that you can do with the mdf and ldf files but there is also a bunch of...
  5. administratorx

    sql server does not exist or access denied...

    Hi, If you are using NT authentication then the problem is that there is not a two way trust between domains. If you use SQL authentication then there should not be a problem. It's only with NT that you need that 2 way trust

Part and Inventory Search

Back
Top