Search my blog
-
-
Recent Posts
- Reading list for the week – 24/10/11
- Reading list for the week – 17/10/11
- Reading list for the week – 10/10/11
- Reading list for the week – 03/10/11
- Reading list for the week – 26/09/11
- MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
- Reading list for the week – 19/09/11
Page Views
283,436-
Popular Posts
- How the Cannot generate SSPI context error was fixed
- Cannot create an instance of OLE DB provider ‘OraOLEDB.Oracle’ for linked server
- Find the SQL Server Instance name using Task Manager
- The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON
- Script to check database user permissions
Archives
Tags
backup configure data corruption data file hardware hotfix index internals locks maintenance plan performance PradeepAdiga restore RLFTW scripts security services setup sql 2000 sql 2005 sql 2008 sql 2012 sql agent ssis system databases tips and tricks tools Top Posts trace transaction log troubleshoot windows
Monthly Archives: September 2010
CmdExec job step does not work as desired
Sometime back I was trying to automate certain tasks by using SQL Agent. For a change I thought of accomplishing it using native DOS commands instead of my favorite T-SQL commands. During that I stumbled upon an interesting limitation of CmdExec job … Continue reading
Posted in SQL Agent, SQLServerPedia Syndication, Troubleshoot
Tagged sql agent, tips and tricks, windows
Leave a comment
Making sense of hexadecimal error codes in Cluster Log
As I was casually going through my mailbox today morning, saw one CheckServiceAlive failure message for one of the Clustered Instances. [sqsrvres] CheckServiceAlive: QueryServiceStatus failed (status 45b). Since I was connecting from home, I did not feel like logging on … Continue reading
Posted in Internals, SQLServerPedia Syndication
Tagged internals, tips and tricks, windows
3 Comments
RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare