Archive for April, 2009

Return a status or value from sp_start_job

In my procedure, I’m calling a job on a remote server and if this call fails, I would like the code to handle it accordingly. So if I get a return value or status of 0, the job started successfully. If 1, then it failed to start.
Now I can’t monitor the entire duration [...]

Thursday, April 30th, 2009

iPhone 3G

The last time I touched an Apple, Inc. device was WAY WAY WAY back in the 3rd grade. Since high school, it has been nothing but PC and Microsoft Windows stuff.
Last weekend, I finally went out to purchase the Apple iPhone 3G. I wanted one since its release but at $600 a pop, [...]

Wednesday, April 22nd, 2009

Creating Windows Clustered Resources

Over the past 3 weeks, I’ve built over 40 pairs of active/active cluster on Windows 2003. I’ve looked around the web, to see if someone has any type of script that will help me, but alas, everyone wants to show me how to PnC (point & click) my way thru the bullshit GUI.
Don’t get [...]

Tuesday, April 14th, 2009

changing sql services password

In my environment, I have over 100+ servers and every so many days, the account that runs SQL services are changed and it is a bitch to change it via point and click on 100+ servers.
Internally, there’s a tool that we all can use to reset password for services except that it isn’t friendly when [...]

Tuesday, April 14th, 2009

sql 2005 connection error

Error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
I have a server named: virtualA\virtualSQLA. This server was working fine a few days ago but [...]

Friday, April 10th, 2009