<quote>

Domain account assigned to MSSQLSERVER service is placed into group NT SERVICE\MSSQLSERVER

Domain account assigned to SQL Server Agent service is placed into group NT SERVICE\SQLSERVERAGENT

This is why you MUST...

That is what I thought.

When we install SQL server, at the step to choose an account for SQL server services, agent services, we use a domain account and entered there.

But...

Thanks

I just added as a step in the ssis to alter the view.

Then I thought I 'd better to check the security, then I noticed the entire package is...

Thanks!

two tables, see my top message shows the view definition

Thanks by the way, because now the current setting for the database file growth I restricted to 20gb, if I change it to unlimited, do I need to restart SQL...

Thanks, for our case it is not a schema bound view, and if I use select column names, it has to explictily list 40 columns, I just think if we...

I think the person runs it knows which query it is.

The server is for a research and evalution department, they only have one server there. and each user has a...

Further experience on the production server, I found if I run the sql statement to change the file size, then I open ssms, it changed there, even I don't restart...

I understand after I restart the service, the changes will take effect if I use the SQL statement to change it.

The thing I don't understand is by using ssms, will...

Thanks.

Is there also a way to change in SSMS, like I said in earlier post it won't save it.

Thanks

Any help please?

Thanks

But how it knows it will change to 10 gb?

I tried to change the size on then database property-file-inital size window, it not save it, when I reopen it, it...

Yes, the mdf file is there too, and I can take ownership and I can rename it, and it is not existing in the masterfiles list