The Ji Village News

Category: SQLServer

  • Quick script to rebuild full text search

    Below is the script I learned while in Seattle attending PASS conference. Some guys from Microsoft helped me to rebuild full text index on some SharePoint databases I manage. select * from sys.fulltext_catalogs sp_configure ‘show adv’,0 reconfigure — Get the fulltext catalog name to rebuild select object_name(object_id), * from sys.fulltext_indexes select * from docs where…

  • PASS Reports 20061116

    It is good to be at PASS Sql Server conference in Seattle. Most people here have this kindred Sql Server spirit. Since we all have this in common, it is easy to start a conversation with pretty much anybody. All you need to do is to smile, greet each other warmly, and share your own…

  • At PASS conference in Seattle

    After 2 hours of flight delay, I’ve made it to Seattle. I am attending PASS Sql Server conference here. No, not the P.A.S.S. above. (I got that picture from a place not too far from where I work in Chicago area.) The PASS I am talking about here is Professional Association for Sql Server. I…

  • Getting Started with PowerShell and SMO

    Microsoft will introduce a new shell with the forthcoming release of Vista. It was code-named Monad initially. Later on it was referred to as MSH (Microsoft Shell). In April, it was officially named as PowerShell. In fact, PowerShell RC2 (Release Candidate 2) is available for download now. I’ve downloaded and played with RC2 and was…

  • Service broker and database mail

    A couple of weeks ago, I set up database mail on one server, and verified that it worked. A few days ago, my friend called because the mail was not working for him. This is the message I got when ran sp_send_dbmail stored procedure: Msg 14650, Level 16, State 1, Procedure sp_send_dbmail, Line 68 Service…