Archive for April, 2009

Return a status or value from sp_start_job

April 30, 2009 Posted Under: sql   Read More

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 of [...]

Creating Windows Clustered Resources

April 14, 2009 Posted Under: sql   Read More

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 [...]

sql 2005 connection error

April 10, 2009 Posted Under: sql   Read More

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 [...]