I was working on a SSIS package in SQL 2014 which was working there without any issues. Due to few factors we need to downgrade to work in SQL Server 2008 R2 for few months. I developed the packages in SQL 2008 BIDS and deployed. No changes done to any of the database objects as I thought I’m going to use the same in my package as well.
I was working on one the project and they were looking for a backup report which should specify whether it’s physical or logical and few more details. Whatever data I fetched looks good and I felt the same can be helpful for you guys to pull it as a report. If you need any more additions to it please let me know.
After couple of years I’m started playing around the pre release packages. Today I installed Windows Server 2016 Technical preview release 3 and SQL Server 2016 CTP 2.4 in my machine to play around the upcoming release.
There are lot of scripts available in the internet to find orphan users across the database.
This will be my version fo script to find out orphan users in all the databases excluding system databases.
After a long break we are back in action . This time we are with two different series. . Hope to you see you all in the meet, please pass this information to all your friends and colleagues so that we can see new faces.
All CSSUG members please register at www.sqlpass.org and select Chennai SQL Server user group as your chapter to get benefited from content and notifications about the event in CSSUG.
Thanks to Ram and Madhi for accepting the Invitations.
Facebook Group – https://www.facebook.com/groups/cssug/
WhatsApp Group – CSSUG
Hike Group – CSSUG
Send an SMS to me to get you added to the group.