I do not think so. You only monitored the numbers of logins and logoffs in your time frame. I cannot see the reasons why they should be the same.

Yes

Thanks all!

I got it with all your helps.

First of all, thank you for your input.

Maybe, I did not state my question clear.

I would like to rename the instance not the computer name. Your link showed how...

It works. Many thanks again.

I mean max number of characters in a text data type field.

If so, any running job will be killed?

@SQLFRNDZ

I cannot get your point.

The weird thing is, I have sa permission on the database server and local admin permission on the...

Make sure the authentication mode is mixed.

Thank you so much for your input.

Here is one more question based on your input:

"As an extreme example, you publishing might have just one record in it which is updated...

Thank you so much for your input. The script you mentioned is for all logins. I would like to have logins only for one specific user database.

Could you help?

Thanks.

Do you have ideas how to de-partition a table?

You are right. Remove all indexes, contraints, ...

"When you say the job is there, what do you mean? Is this a package execution or stored procedure? Have you looked at the code to see if there could...