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

    Using Parameters in a Stored Procedure

    If you still have the 'pubs' database on your install... CREATE PROCEDURE byroyalty @percentage int AS select au_id from titleauthor where titleauthor.royaltyper = @percentage GO ...this stored proc is still there. Execute the stored proc... EXEC byroyalty @percentage = 100
  2. rdl1206

    log file for database 'tempdb' is full. Back up the transaction log fo

    hoggle, Make sure that you have all your sysdatabases in your maintenance plan. When you are sure you have a good database and transaction log backup, you can run... BACKUP LOG tempdb WITH TRUNCATE_ONLY in Query Analyzer.

Part and Inventory Search

Back
Top