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 IamaSherpa 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. gday2u

    Echo sql which has run in a script

    I am relatively new to SQL Server. I have a command file with the following contents : osql -E -i%1.sql -d%2 -oq:\%1.log The sql script file has a number of insert/update statements. The log file produced looks something like this : 1> 2> (1 row affected) 1> 2> (1 row affected) 1> 2> (0 rows...
  2. gday2u

    Editing a table in Query Analyzer

    I am trying to update some rows in a table using Query Analyzer. Using the Object Browser and selecting one of the User Tables,I then right click on this table. I can click on the Open option to view all rows but I want to choose the Edit option but it is dimmed. Is there some setting that needs...
  3. gday2u

    Transaction log is still full after backup with truncate_only

    I am running SQLServer 2000. I have a database which is in Simple recovery mode. There is a DTS package which I run everynight which copies data from an external data source. However, it tells me that the transaction log for the database is full. I have put the following SQL task as the first...
  4. gday2u

    Keeping a database in synch between a server and laptops

    We have a situation where we have a database on an enterprise server which needs to be replicated onto a number of laptops. These laptops go out into the field and may need to be updated from the enterprise server database several times each day. The enterprise database is approximately 2 Gig...
  5. gday2u

    delete old files using tsql

    I am relatively new to SQLserver and I am putting together some TSQL code to backup our databases and transaction logs. I want to also include some code which will delete backup files older than a specified number of days. Has anyone written some code to do this ? TIA
  6. gday2u

    Log file full while in simple recovery mode

    I am new to SQLServer so please be gentle ;) I have set up a DTS package in SQLServer200 to populate tables in a database. The recovery mode is simple yet I am getting the message: The log file for database 'bwtest' is full. I was lead to believe that transaction logging did not occur in...

Part and Inventory Search

Back
Top