It rolls back, same as any other data modification when stopped part way through.

Rather use impersonation and just have that login having the permissions. Shouldn't be SA though. I don't think you can get the DB in a login trigger, it fires too...

It's needed for a couple of small things like transaction rollbacks and crash recovery on restart (ensuring a consistent database)

If there was no transaction log, then any failure in any...

You're welcome to your opinions, just don't expect them to held as universal definitions.

Yes, that's why I said 'Leaving it to you to change the variables, fetch statements, etc.'

If you change the cursor definition, you'll have to change the fetch statements, add variables,...

The filter is on the join and it's an outer join. So the filter is done before the join then the left join joins in the matching rows, while also...

Look at the first changes, to the cursor

It is.

If I'm moving databases from one instance to another, I'll use backup/restore. It definitely is a way to move databases.

Two places that need to change.

First, the cursor definition

declare FindFragment cursor for

SELECT object_id, name FROM #IndexFrag WHERE (avg_fragmentation_In_Percent > 5) and (avg_fragmentation_In_Percent < 40) and (name not like 'null')

because index...

Or better yet, create a good clustered index and don't drop it.

You did not need to take the instance down.

After running the alter database, take the database offline, ensure the files really are in the correct place and that SQL has...

Using ALTER DATABASE to move a user database file doesn't require a service restart.

Run the ALTER DATABASE

Take that DB offline

Go to the file system

Move the database's files to the new...

Login triggers fire early in the connection process, before the switch to the requested DB happens. That's why you need the 3-part table name and why you only see master.

As...

Then...

INSERT INTO <database name>.<schema_name>.Audit_Log...

and what messages (in the error log) does the revised trigger above produce?