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

  • Users: sheong
  • Content: Threads
  • Order by date
  1. sheong

    SQL Server 7 - Install Service Pack 4

    hi there, I have a server running NT 4 (SP6a) and SQL Server 7 (without service pack). I am reliazed that sqlservr.exe occupied alot of memory and never release after been used. Is it a bugs of MS SQL Server 7 ? Or is it the nature of SQL Server 7 ? I am planning to upgrade the SQL Server...
  2. sheong

    Print "Only the Selected Frame"

    Hi, i trying to use print preview in my asp page contain 3 frames. I using the following function, I able to do the print preview. But it is always default to "As laid out on Screen". How can i modify the following function so that it can set it to "Only the Selected...
  3. sheong

    Database Integrity Check in Maintenance Plan

    Hi, "Attempt to repair any minor problems" in the database Integrity Check". May i know what are the minor problems meants ? How the SQL Server repair it ? Thank you!
  4. sheong

    MS SQL 2000 - LDF 3G , can shrink it ?

    Hi, I have a database contain 1 LDF in 3G, but MDF only 1G. Can i shrink the LDF file to 1M? How to do it ? What is the impact to MDF if i shrink the LDF ? Thank you!
  5. sheong

    How MS SQL Server Transaction Logs Work?

    Hi, I'm new SQL database administrator. May i know how MS SQL Server Transaction Log works ? Is it every time when the COMMIT statement issues, SQL Server will write the data in the database file ? How come after i did the full backup, my LDF file size not reduce? I thought SQL Server...

Part and Inventory Search

Back
Top