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 Mike Lewis 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. Terryute

    SQL 2000 Backup Problems

    Have you tried incremental log backups? Backing up the log file is much faster. How it works: All current data being read to and from the database is actually going in your log file. At a checkpoint the data is transferred to the actual database file. If you fully backup your database on...
  2. Terryute

    List stored procedures name and parameters

    Use this query in any database as each database has it's own procs. Select Name From Sysobjects where xtype = 'p' below optional for specific type searches: and Name like '%<search criteria>%' The master database usually only stores system procs. User defined procs usually reside in in...
  3. Terryute

    Copy data from one table to another at different database

    if you are in the 'dog' database.. insert into cat..ans2 select * from ans1 or from the 'cat' database.. insert into ans2 select * from dog..ans1 Tables would need to be identical in order for this to work.
  4. Terryute

    sp help

    Did you try Select Contributor, Medal, Count(*) From Table Group by Contributor,Medal Order by Contributor
  5. Terryute

    Secure Replication over the TCP/IP

    A Virtual Private Network or VPN will work for a secure internet connection.

Part and Inventory Search

Back
Top