You don't give us much to go on except to say it's broke.

With that in mind, check the profile(s) and make sure one of them is setup as a default.

Itzik Ben-Gan wrote an incredible article on this subject.  You can find it at the following URL:

https://blogs.solidq.com/en/sqlserver/packing-intervals/

Because you're not using SQL Server 2012 or above, we can't use his...

Perhaps the following will help...

https://www.databasejournal.com/features/mssql/using-powershell-to-generate-logins-server-and-database-permissions.html

What you need to do now is figure out why the data became corrupted.  Do you have a disk or controller going bad?  Was there a sudden power outage that...

The Generate Scripts is at the database level so that can also cause some problems - the logins need to be there as that tool generates statements like CREATE...

Considering the content of the delete table, I'm thinking that you also need to include the ID in the delete criteria.

Whenever someone proposes such a massive change, I always ask them to show me their prototype and prove that it can actually do the job.  I'm sometimes overridden but my...

Yes... tell them sorry but NO.  There should never be shared logins, period.  The closest you should ever come to something like shared...

p.s.  Stop doing REORGANIZE on tables that don't have LOBs or tables that do have them but they don't need to be compacted.  You're just blowing out your log file...

Yes... carefully read the documentation that Ola provides...

One should always try to avoid a function on a table column being used for lookup.  Therefore, for the last JOIN, do this instead:

 ...

sp_Help_RevLogin does not migrate server level privs.  You'll need to do a search for a proc the will generate a script for those privs.

What do you mean when you say "but still people can login using exponential numbers"?

TF 1118 and 1117 are automatically implemented in 2016.  You can turn them off for all databases except for TempDB.  I wouldn't turn 1118 off anywhere but I...

I agree with the others about MAXDOP and Cost Threshold for Parallelism (CTP from here on) being more of an observational art rather than a science.  I also agree that...