The Ji Village News

In SQLCMD, if you type ed, it will invoke a text editor and put the last command you run in the editor buffer. The default editor is Edit, a command line editor of DOS. This behavior is very similar to Oracle Sql Plus, by the way. The difference is that in Sql Plus, you can…

SQLCMD is a command line utility for Sql Server 2005. Like osql and isql, it can be used interactively. It can also be used as a scripting tool to automate a lot of routine tasks. It is the later part that I find exciting and fun. (By the way, isql is not available in Sql…

By now, you probably know that in SQL Server 2005, a new tool that replaces SQL Server Enterprise Manager and SQL Server Query Analyzer is SQL Server Management Studio (SSMS). It has a lot of good stuff in it, one of them being the reports. SSMS reports provide a snapshot of your server status and…

I blogged about my 2 failed attempts of silent / command line install of SQL Server 2005 September CTP. So I filed a bug here on MSDN. I am impressed that Microsoft responded very quickly, saying this is not a bug. Thanks to whoever closed the bug. That was a real quick response:) I will…