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. setsuna

    Writing the results of a query to a file?

    from query analyzer click on the query menu and then click on Results to File, once you have done this, highlight your query and run it, before it will run you will be prompted to enter a file name.
  2. setsuna

    How do I iterate thru a table, 1 rec at a time?

    A cursor is the only way I know to do a row by row, but they are very time consuming. Especially with large data. You may want to break your process down into smaller steps. First you could create an intermediary or temporary table that has only members which are currently active: example...
  3. setsuna

    truncating tempdb?

    From enterprise Manager : you can click on tempdb, right mouse click, select all tasks, select shrink database , set maximum free space in files to 0% and then hit ok. If you want to do this from the Sql Query analyzer you can type : dbcc shrinkdatabase(tempdb) and then highlight and run
  4. setsuna

    Is there any way to expedite the recovery of a database?

    Hello, My question may be dumb, but desperation causes me to ask it anyway: I have created an instance of SQL SERVER 2000 on my PC(which is not ideal, but the server wont be here for a couple of more weeks so my pc is all the hardware I have to work with). I have a problem, the machine was...

Part and Inventory Search

Back
Top