Activity overview
Latest activity by Cat_Bill
SSMS / comments
SSMS
Alter instead of drop and recreate
Is there a way to force SQL Change Automation to use alter instead of drop and recreate when renaming a table? I don't want to lose the data in the table.
Figured out my own problem. Users were given access to model database. When they were deleted from SQL Logins, they were not deleted from the model database. When the shadow copy of the database is created it uses the model database and then seems to be updated by the main database it is a shadow of. / comments
Figured out my own problem.Users were given access to model database. When they were deleted from SQL Logins, they were not deleted from the model database. When the shadow copy of the database is...
Why do users show up after deletion
I have taken a datase instance and removed all users and logins except for sa.Connected to instance with SA and deleted users. Cloned the database and restored it and then run SQL Automation on a d...
I was able to confirm there is no proxy! / comments
I was able to confirm there is no proxy!
There could be a proxy do to the connections between Azure and our servers. Is there a way to disable the check? I don't have control over the network. / comments
There could be a proxy do to the connections between Azure and our servers. Is there a way to disable the check? I don't have control over the network.