Before a week ago, I shared one post related to this title. Please read first workaround for same. I hope you liked it. Here I would like to share another way which may drive towards alternative solution to get it resolved. Alternate workaround : ...

As i have wrote the article to clean up the old database backup for the maintenance activities. Same thing i am doing here as a maintenance activity but not for the database backup clean up, It is for database backups history clean from MSDB database. ...

Most of developers, DBA or any persons who are working with SQL server, they have seen the error which i mentioned in title. From the error you can easily imagine there is a something error in Server name which are trying to connect server. But when thi...

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