Thanks, that makes sense,...

Jeff, not sure I understand this, when you say:

"I would probably not do that - instead, I would use proxy accounts to grant the appropriate rights needed for each job....

Yes, it has to be truncate table, and it will not do delete records from the table, but will insert records into the table.

Thanks, but not sure how for this one it enhances security for using ssms?

Thank you, it helps a lot

Thanks, good tips.

Yes, it helps a lot.

I understand most part now.

only for Exec @rc=

it returns the succssful or failure result and it stored in @rc,

but why store it?

I see there...

Thanks all for the help, I will look more into it.

I would like to make the script to be portable for all other databases, each time I just need to change the database name, I know how to write a...

After network guys fix switch, I did a dbcc checkdb like above.

it returns Command(s) completed successfully.

I guess the file is OK.

Thanks

We found out there are san and switch issues with our network.

Thanks, I tried, it works perfectly

Thank you. That's a good idea.

What's the difference between transaction log back and log tail backup, so far I have not used log tail backup, when should we use it?

I think we have the regular bandwith just as other companies have.

Not sure how long it will take to copy 100gb files.

I figured out with a windows guy.

When I right click the file, only one person is shown on the list- old dba has full control to that file. No one...