-
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…
-
Sql Server Browser needs to be started for remote connection to a named instance
A default installation of Sql Server 2005 is pretty easy. After install, you can connect to it remotely, either through Sql Server Management Studio or sqlcmd. However, if you install a named instance on the same box, you may not be able to connect to it remotely, although connecting to it locally would still work.…
-
Issues connecting to SSIS and browsing packages in msdb when database service is clustered
In Sql Server 2005, you cannot cluster Sql Server Integration Service (SSIS). During database cluster install, you can pick to install Integration Service. SSIS will only be installed on the node where installation process starts from. For example, suppose you have Node1 and Node2, and the install is started from Node1, then database service and…
-
Grant database read/write access to Windows login
Regular readers may have noticed that I am a big fan of automation. As such, for repetitive tasks, I prefer scripting over point and click. Nothing wrong with point and click though. For one time task, I don’t mind using GUI to get it done quickly. Repetitive is the key word here. Below is a…