---
 
 
---
 
 
Smilepk Home | Tips Home | Contact | Games | Themes | Wallpapers | Videos
GOOGLE
Free SEO, Web Related Tips
    Web Hosting Guide
    SEO Articles, Tips
    Earn With Google
    Hot n Top Tips
    Mix Web Special
    Miscellaneous Tips
---
Free Windows xp Tips
    User Interface
    Usability Tweaks
    Security Tricks
    Hardware Tweaks
    Internet & Network
    System Performance
    Miscellaneous Tips
    Software Tips
---
Today World Tips
    Travelling Tips
    Cooking Tips
    Credit Card Tips
    Photography Tips
    Handwriting Tips
    Student Visa Tips
    Resume Tips
    Aloe Vera Tips
    Weightloss Tips
    Beauty Tips
    Mobile Codes Tips
---
Free Other Categories Tips
    PC Buying Tips
    System Tune-Up
    MS Office Tips
    Security Alerts
    Database Tips
    Registry Tricks
    Pc Troubleshooting
    Backup Tricks
    Printing Tips
    Cisco Router Tips
    Glossaries...
    Laptop Tricks
    PC Cleaning Tips
    System FAQs
    Internet Tips
    Windows Vista Tips
---
Free Broadband Tips
    ISP Tricks
    Wireless Tips
    VPN Tricks
    Mobile Tips
    ATM Tips Tricks
    Optic Fiber Tips
    Cable Net Tweaks
    DSL Tips Tricks
    Projector Tips
     Home   Database Tips
----
----
            DATABASE ADMINISTRATION TIPS
Adding Columns to Replicated Tables
Avoiding the Autoclose and Autoshrink Options
Backing Up to a File on a Network Share
Benefits of Using SQL Server 2000 Enterprise Edition
Case-Sensitive Comparisons
Changing Code Page from SQL Server 7.0 to SQL Server 2000
Changing the Database Owner (dbo) Account to System Admin
Checking Port Numbers
Configuring a Mail Profile for SQL Server
Does Auto growth Block Updates?
Does Sort Order Affect Performance?
Ensuring All Non-NULL Values Are Unique
Ghost Record Cleanup and Error 602
Granting Permissions on Database Objects
Horizontally Partitioned Merge Publications
How to Find Out Whether a SQL Server 2000 Installation Is 32-Bit or 64-Bit
How to Manage Multiple Developers Using the System Administrator Account
I'm Locked Out of SQL Server. How Do I Get Back In?
Investigating Date Errors
Log File Growth and DBCC DBREINDEX
Managing Result Set Paging
Moving Transaction Logs to a Different Drive
Open UDP Port 1434 to Browse Named Instances
Performing a Log Shipping Role Change
Reinstalling SQL Server on a Failed Node
Rolling Back a Transaction in the Transaction Log File
Running a DTS Job on a Second Computer
Running Virus-Scanning Software on the Same Server as SQL Server
SQLAgentCMDExec Permissions
SQL Server Profiler and Parameterized Statements
Table Access During Index Build
Updating Columns from One Table to Another
Using Extended Properties to Create a Data Dictionary
Using a SQL Server System as a PDC
Using Views to Control User Access to Data