MSSQLCity.Com - All about MS SQL
     
 About Us  
 SSWUG Articles  
 Articles  
 FAQ  
 Scripts  
 Tips  
 Test Exams  
 Advertise  
 Download  
 Search  
 Related Links  
     
Your button logo
Add to Favorites
 
     
 

History

|2003|2002|

December 29, 2002.

Two FAQ questions were added:
How do I get the date the object was created?
How do I run SQL script located on the disk file, using Transact-SQL?

MSSQLCity.Com contains:

  • 60 articles
  • 122 FAQ questions
  • 27 scripts
  • 197 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • December 22, 2002.

    New Tips topic with 12 tips was added:
    Stored Procedures Optimization Tips

    MSSQLCity.Com contains:

  • 60 articles
  • 120 FAQ questions
  • 27 scripts
  • 197 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • December 15, 2002.

    Four FAQ questions were added:
    How do I add 'n' working days to the given date and get the result date?
    How do I get working days between two dates?
    How do I return the first day of the month for the given date?
    How do I return the last day of the month for the given date?

    MSSQLCity.Com contains:

  • 60 articles
  • 120 FAQ questions
  • 27 scripts
  • 185 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • December 8, 2002.

    New Tips topic with 12 tips was added:
    Backup/Restore Optimization Tips

    MSSQLCity.Com contains:

  • 60 articles
  • 116 FAQ questions
  • 27 scripts
  • 185 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • December 1, 2002.

    Three FAQ questions were added:
    How do I go about using/changing my settings to use the SANs protocol?
    How do I report information about current users and processes?
    How do I report information about the active locks?

    MSSQLCity.Com contains:

  • 60 articles
  • 116 FAQ questions
  • 27 scripts
  • 173 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • November 24, 2002.

    One T-SQL script was added.
    One SQL Server 6.5 script was added.

    MSSQLCity.Com contains:

  • 60 articles
  • 113 FAQ questions
  • 27 scripts
  • 173 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • November 17, 2002.

    This article was added:
    How to troubleshoot backup/restore problems

    MSSQLCity.Com contains:

  • 60 articles
  • 113 FAQ questions
  • 25 scripts
  • 173 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • November 10, 2002.

    Three FAQ questions were added:
    Can I work with registry from within T-SQL?
    How can I create extended stored procedures?
    How do I move tables from one filegroup to another?

    MSSQLCity.Com contains:

  • 59 articles
  • 113 FAQ questions
  • 25 scripts
  • 173 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • November 3, 2002.

    New Tips topic with 14 tips was added:
    DTS Optimization Tips

    MSSQLCity.Com contains:

  • 59 articles
  • 110 FAQ questions
  • 25 scripts
  • 173 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • October 27, 2002.

    Three FAQ questions were added:
    I can run DTS package myself, but cannot schedule it.
    I get the full-text search timeout error. How can I fix this?
    Why DTS Import Wizard fails when importing table with a timestamp column?

    MSSQLCity.Com contains:

  • 59 articles
  • 110 FAQ questions
  • 25 scripts
  • 159 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • October 20, 2002.

    This article was added:
    How to troubleshoot DTS problems

    MSSQLCity.Com contains:

  • 59 articles
  • 107 FAQ questions
  • 25 scripts
  • 159 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • October 13, 2002.

    New demo exam with ten questions was added:
    MS SQL Server 2000 Administration

    MSSQLCity.Com contains:

  • 58 articles
  • 107 FAQ questions
  • 25 scripts
  • 159 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • October 6, 2002.

    New Tips topic with 20 tips was added:
    Replication Optimization Tips

    MSSQLCity.Com contains:

  • 58 articles
  • 107 FAQ questions
  • 25 scripts
  • 159 tips
  • 3 test exams (on 75, 70 and 10 questions)


  • September 29, 2002.

    Two FAQ questions were added:
    Can you give me the links to upgrade from SQL 7.0 to SQL 2000?
    Should I apply the SQL service packs in order or can I just apply the latest one?

    MSSQLCity.Com contains:

  • 58 articles
  • 107 FAQ questions
  • 25 scripts
  • 139 tips
  • 3 test exams (on 75, 70 and 10 questions)


  • September 22, 2002.

    This article was added:
    How to troubleshoot replication problems

    MSSQLCity.Com contains:

  • 58 articles
  • 105 FAQ questions
  • 25 scripts
  • 139 tips
  • 3 test exams (on 75, 70 and 10 questions)


  • September 15, 2002.

    Three FAQ questions were added:
    How can I rebuild the SQL Server repository?
    I am a dbowner. Can I restrict access to my database for the 'sa'?
    Where can I find the list of bugs fixed by SQL 2000 service packs?

    MSSQLCity.Com contains:

  • 57 articles
  • 105 FAQ questions
  • 25 scripts
  • 139 tips
  • 3 test exams (on 75, 70 and 10 questions)


  • September 8, 2002.

    New Tips topic with 14 tips was added:
    Full-Text Search Optimization Tips

    MSSQLCity.Com contains:

  • 57 articles
  • 102 FAQ questions
  • 25 scripts
  • 139 tips
  • 3 test exams (on 75, 70 and 10 questions)


  • September 1, 2002.

    Four FAQ questions were added:
    What are good SQL Server web resources?
    Where can I download free case tools?
    Where can I download SQL Server 2000 Books Online?
    Where can I see the price-list for SQL Server?

    MSSQLCity.Com contains:

  • 57 articles
  • 102 FAQ questions
  • 25 scripts
  • 125 tips
  • 3 test exams (on 75, 70 and 10 questions)


  • August 2, 2002.

    This article was added:
    How to troubleshoot full-text search problems

    Two Miscellaneous optimization tips were added.

    MSSQLCity.Com contains:

  • 57 articles
  • 98 FAQ questions
  • 25 scripts
  • 125 tips
  • 3 test exams (on 75, 70 and 10 questions)


  • July 28, 2002.

    Two FAQ questions were added:
    How can I send a message to user from the SQL Server?
    How do I run a T-SQL script through SQL-DMO?

    MSSQLCity.Com contains:

  • 56 articles
  • 98 FAQ questions
  • 25 scripts
  • 123 tips
  • 3 test exams (on 75, 70 and 10 questions)


  • July 21, 2002.

    New demo exam with ten questions was added:
    MS SQL Server 2000 Development

    MSSQLCity.Com contains:

  • 56 articles
  • 96 FAQ questions
  • 25 scripts
  • 123 tips
  • 3 test exams (on 75, 70 and 10 questions)


  • July 14, 2002.

    This article was added:
    Setup full-text search: step by step guide

    MSSQLCity.Com contains:

  • 56 articles
  • 96 FAQ questions
  • 25 scripts
  • 123 tips
  • 2 test exams (one contains 75 questions, another contains 70 questions)


  • July 7, 2002.

    Two FAQ questions were added:
    How can I get the column's description from my stored procedure?
    I got an error that RPC is not enabled. How can I enable RPC?

    MSSQLCity.Com contains:

  • 55 articles
  • 96 FAQ questions
  • 25 scripts
  • 123 tips
  • 2 test exams (one contains 75 questions, another contains 70 questions)


  • June 30, 2002.

    Two T-SQL optimization tips were added.

    MSSQLCity.Com contains:

  • 55 articles
  • 94 FAQ questions
  • 25 scripts
  • 123 tips
  • 2 test exams (one contains 75 questions, another contains 70 questions)


  • June 23, 2002.

    Two FAQ questions were added:
    How can I fix lost users after attaching database with sp_attach_db?
    How to troubleshoot SQL Server installation problems?

    One T-SQL script was added.

    MSSQLCity.Com contains:

  • 55 articles
  • 94 FAQ questions
  • 25 scripts
  • 121 tips
  • 2 test exams (one contains 75 questions, another contains 70 questions)


  • June 16, 2002.

    Four SQL Server 6.5 optimization tips were added.
    Three questions were added in MS SQL Server 7.0 Administration questions pool.

    MSSQLCity.Com contains:

  • 55 articles
  • 92 FAQ questions
  • 24 scripts
  • 121 tips
  • 2 test exams (one contains 75 questions, another contains 70 questions)


  • June 9, 2002.

    Four FAQ questions were added:
    Can I use the SQL Server 7.0 tools to connect to SQL Server 2000?
    How can I check from the SQL Server whether the file exists or not?
    How can I decrypt a SQL Server stored procedure?
    How can I remove foreign keys through SQL Server 7.0/2000 Enterprise Manager?

    MSSQLCity.Com contains:

  • 55 articles
  • 92 FAQ questions
  • 24 scripts
  • 117 tips
  • 2 test exams (one contains 72 questions, another contains 70 questions)


  • June 2, 2002.

    Two FAQ questions were added:
    How can I add SQL Server licenses?
    How is SQL Server licensed?

    Two Operation System optimization tips were added.

    Three questions were added in MS SQL Server 7.0 Development questions pool.

    MSSQLCity.Com contains:

  • 55 articles
  • 88 FAQ questions
  • 24 scripts
  • 117 tips
  • 2 test exams (one contains 72 questions, another contains 70 questions)


  • May 26, 2002.

    One T-SQL script was added.
    One SQL Server 6.5 script was added.

    Two questions were added in MS SQL Server 7.0 Administration questions pool.

    MSSQLCity.Com contains:

  • 55 articles
  • 86 FAQ questions
  • 24 scripts
  • 115 tips
  • 2 test exams (one contains 72 questions, another contains 67 questions)


  • May 19, 2002.

    This article was added:
    Using SQL Server Cursors

    New Tips topic with 9 tips was added:
    Cursor Optimization Tips

    MSSQLCity.Com contains:

  • 55 articles
  • 86 FAQ questions
  • 22 scripts
  • 115 tips
  • 2 test exams (one contains 70 questions, another contains 67 questions)


  • May 12, 2002.

    This article was updated:
    Date and Time User-Defined Functions

    Four FAQ questions were added:
    Where can I find MSSQL test exams?
    What is the current service pack for SQL Server 7.0?
    What is the current service pack for SQL Server 2000?
    Where can I find the list of bugs fixed by SQL 7.0 service packs?

    Two questions were added in MS SQL Server 7.0 Development questions pool.

    MSSQLCity.Com contains:

  • 54 articles
  • 86 FAQ questions
  • 22 scripts
  • 106 tips
  • 2 test exams (one contains 70 questions, another contains 67 questions)


  • May 5, 2002.

    Four SQL Server 2000 optimization tips were added.

    Three questions were added in MS SQL Server 7.0 Administration questions pool.

    MSSQLCity.Com contains:

  • 54 articles
  • 82 FAQ questions
  • 22 scripts
  • 106 tips
  • 2 test exams (one contains 70 questions, another contains 65 questions)


  • April 28, 2002.

    Two FAQ questions were added:
    Some of my text/image values were not replicated. What is the problem?
    Where does snapshot replication store replicated data?

    Two questions were added in MS SQL Server 7.0 Administration questions pool.
    Two questions were added in MS SQL Server 7.0 Development questions pool.

    MSSQLCity.Com contains:

  • 54 articles
  • 82 FAQ questions
  • 22 scripts
  • 102 tips
  • 2 test exams (one contains 67 questions, another contains 65 questions)


  • April 21, 2002.

    Three FAQ questions were added:
    Can I backup a database to a network device?
    How do I restore the master database?
    We have no any backup, can we restore deleted data?

    One T-SQL script was added.
    One SQL Server 6.5 script was added.

    MSSQLCity.Com contains:

  • 54 articles
  • 80 FAQ questions
  • 22 scripts
  • 102 tips
  • 2 test exams (one contains 65 questions, another contains 63 questions)


  • April 14, 2002.

    Two SQL Server 2000 optimization tips were added.

    Five questions were added in MS SQL Server 7.0 Administration questions pool.
    Three questions were added in MS SQL Server 7.0 Development questions pool.

    MSSQLCity.Com contains:

  • 54 articles
  • 77 FAQ questions
  • 20 scripts
  • 102 tips
  • 2 test exams (one contains 65 questions, another contains 63 questions)


  • April 7, 2002.

    This article was updated:
    SQL Server 7.0: Some useful trace flags

    Two FAQ questions were added:
    How can I compare the data in two tables with identical structure?
    How can I compare two databases?

    New Tips topic with 8 tips was added:
    SQL Server 2000

    MSSQLCity.Com contains:

  • 54 articles
  • 77 FAQ questions
  • 20 scripts
  • 100 tips
  • 2 test exams (one contains 60 questions, another contains 60 questions)


  • April 1, 2002 - the site birthday.

    MSSQLCity.Com contains:

  • 54 articles
  • 75 FAQ questions
  • 20 scripts
  • 92 tips
  • 2 test exams (one contains 60 questions, another contains 60 questions)


  • |2003|2002|

     
    Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

    (c) 1997, 2005 Bits on the Wire, Inc