Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to remove (clean-up) tsqlt from the SQL Server? #186

Open
ZedZipDev opened this issue Dec 22, 2022 · 1 comment
Open

How to remove (clean-up) tsqlt from the SQL Server? #186

ZedZipDev opened this issue Dec 22, 2022 · 1 comment

Comments

@ZedZipDev
Copy link

The script tsqlt.clas.sql is not re-enterable.
I run it first time and received a lot of errors like owner sid of the db differs from owner's sid of master db. But after the 2nd run of the same script I have received messages about object already exists etc.
I am sure need to avoid this kind of statements but the script contains them
CREATE SCHEMA tSQLt;
GO
Need to check if exists etc.
Ok.
How to remove (clean-up) tsqlt from the SQL Server?

@mbt1
Copy link
Collaborator

mbt1 commented Dec 22, 2022

The tSQLt.class.sql script is idempotent, as it automatically removes tSQLt completely before creating new objects. However, if the install fails due to unforeseen circumstances, like a previously corrupt database or permission issues, that uninstall portion of the script might not work correctly.

To address that, we should add an independent uninstall tSQLt script to the download. Note: In the case of a previously corrupted database, this clearly can do only a best effort.

Thank you for bringing this to our attention.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants