Thank you,  found it.

And I can run in sqlcmd mode in ssms.

But if I run in comand line, it still gives the error: sqlcmd is not recognized as an internal...

Thanks, yes, I know I can do a separate download.

But just wonder if install SSMS by default also installs sqlcmd.

I had SSMS 18.4 installed (newest) , but apparently the sqlcmd...

Thank you all

No, I only reindex at weekend. And I don't see other jobs there.

I will change it to compressed backup to see if it makes a difference

I am using maintenance plan to do full and differential backup.

And I see there is a differential backup file every week day.

• This reply was modified 5 years, 10 months ago by sqlfriend.

This is different.

The database in this case has little update daily, in fact nobody is using it.

I know I can use the script, but SSMS is a tool that is used so often , you can also generate script from there.

But I just want to know...

My network engineer installed Ubuntu for me, he said he installed the server version. He said REDHAT actually is not free.

Yes, I understand Centos is the free version of RHEL.

Thanks much!

Thanks, I love ubuntu too for desktop.

But for this purpose, I am exploring for using it later in production database server.

Maybe this is more tendency to redhat.

If you download the SSDT for visual studio 2017, the newest version on page at middle of the page...

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

I believe you will see the build number in your visual studio...

Also you are correct about the project that is opened later by a user that uses 14 version and the project script component does not work any more, we have...

Thanks much!

About the version of the SSIS,  I downloaded the SSDT data tool for VS 2017, how come it goes with SSIS designer version of 2019?

My version is 15.0.0900.30 if...

Thanks Jeffery.

I think that is what I am going to do.

Thanks Jeff.

Yes, I found too that many things that can be done in SSIS  which can be done more efficiently in T-SQL.

The thing I am working on is two data...