The Ji Village News

Category: Technology

  • Executing sql scripts using command line tools

    SQL Server 2005 has a command line tool named sqlcmd. MySQL has a command line tool named mysql. Oracle has a command line tool called sqlplus. They can all be used for interactive query processing and batch scripts processing. They do similar things, albeit in different ways. They are functionally equivalent. For SQL Server 2005,…

  • desc is sp_columns in Sql Server

    In Oracle and MySql, to get the column name and data type of a table, you can use: desc MyTable or describe MyTable The equivalent of desc in Sql Server is sp_columns. Therefore, run the command below will get similar results: sp_columns MyTable

  • Troubleshoot Sql Server cluster and ClusterRecovery

    With some San disk configuration and drive letter changes, a two-node 64-bit Sql Server 2005 cluster on Windows 2003 boxes would not start, as evidenced in Cluster Administrator. Here are some errors in Event Viewer: Sql Server application error in Event Viewer [sqsrvres] OnlineThread: Error 435 bringing resource online. Sql Server Agent [sqagtres] CheckServiceAlive: QueryServiceStatus…

  • 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…