Great article, Appreciate for explaining in details.

One issue / bug to report :

There's an issue with "databaselevel" report for a domain account (domain\username) when its mapped to a user without...

• This reply was modified 3 years, 11 months ago by  Ash.
• This reply was modified 3 years, 11 months ago by  Ash.
• This reply was modified 3 years, 11 months ago by  Ash.

Forgot to mention, Encryption key no longer available. FOllowing steps on this link: https://docs.microsoft.com/en-us/sql/integration-services/backup-restore-and-move-the-ssis-catalog?view=sql-server-2014

You can add this to your code to dynamically pick the default profile name value from the instance.

declare @profile_name varchar(56)

select @profile_name = a.name

from msdb..sysmail_profile as a

inner join msdb..sysmail_profileaccount as...

Useful script, if you have only "sql authenticated" accounts in your environment.

Two Drawback that I could see are:

1. Script will NOT be useful for checking orphaned "Window users" and...

Thanks for the share.

@penglin,

For multiple database files, you can use something like below. Add it to the original code or write up something

---this script generates create snapshot code. run...

Fantastic job. Thanks for sharing. 🙂

SQLAli,

Just in case, you do not want to use MS Office, you can create a case statement as below and script out the move templates for creating restore script. You...

No reply from anyone means It can not be possible?

I was thinking to create a link server on each server.

Well I tried all the options but still no use of resource database at all to rollback any patch.

Yes; That I know of.. Thanks for the reply.

Can anyone know if Resource database can be used anyhow to rollback any patch or service packs on SQL 2008 server?...

Yes I did; Manual checkpoint completed successfully within less than a second. That background process still there. Lets see if SQL Server clears it out by tomorrow or so.

Anyone??

It seems like you have alias (sqldev) created for the named instance(SQLdev\dev) that you have installed. We had this setting here too. Why this was setup because sometime...

Gail - Is there any article for the same? Wanted to read and update myself. It's better to be late than never.

Thanks,

AB

While creating Database if i create .mdf, .ndf & .ldf are in three different drive. Than my data should be automatically store in .mdf & .ndf...

It is right or some...