Backup and restore database activity is common and routine task for all DBA when need to move database at another place. I did the same thing while needed to move database from one server to other server. But suddenly  i encountered one issue while...

A few days before, i just posted one article to check running scheduled jobs and i used master.dbo.xp_sqlagent_enum_jobs system objects and joined with dbo.sysjobs object from msdb database for same. Please read that post before moving down. This was on...

Some days ago, i worked to get failed jobs detail and an alert for the same. I used some system tables from msdb database to fetch the details for same. And msdb.dbo.sysjobhistory is one of the table among them which used in the script. But this table n...

...

...

Few days back, i was working to add new table in publication in transaction publication. After adding a article in publication and after reinitialized, i see nonclustered index was not copied at subscriber database. I tried reinitialized one more time a...

A few days back, while i was working with Alerts for failed scheduled jobs and missing scheduled jobs, i was needed to exclude running jobs. So we can exactly know which jobs are actually failed excluding running jobs and sane case for missing jobs. I a...

...

Recently while working with one query to get schedule jobs status, i used xp_sqlagent_enum_jobs object which gives details of state values of all jobs in msdb database and this is undocumented object. But received an error while running following query ...

...