schemazen
schemazen copied to clipboard
sethreno
Script and create SQL Server objects quickly
Possible typo in string "numberic" in member HasMaxLength in UserDefinedType, file UserDefinedType.cs. If it's not a typo, which seems quite unlikely, then a comment about that in the source would...
Unit test TestMultiColumnKey in file ForeignKeyTester.cs has no [Test] attribute.
 Reverting this file back to the previous revision removed the compile errors. Was this an accidental bug or am I missing something else?
Jobs are stored in the msdb database, but inside tables, not as code explicitly. I run this snippet to get their code, but wonder if there's something better (and not...
hi, i have a problem with someone write arithmetic data in database the backup process was successfull, but restore process was error here was the sample of data tsv which...
Dear folks, Wondering if it does supports generating Fulltext Catalog ? Could not find any refs. Thanks.
Compare diff run as-is errors on computed columns, despite that in SQL Server cannot be directly altered. They must instead be dropped and added. See https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-2017#arguments
The logical ordering of ? : ? failed to parse correctly in VS2019 on windows. Added ( ) to resolve issue
Modifies the scripting of routines to modify the text of the script to match current action (create or alter), name, and schema/owner. There are actions that you can take in...
Hi, I'm getting the following errors when running the Script option with SQL Server 200R2 EXPRESS The multi-part identifier "CHECK_CONSTRAINTS.CONSTRAINT_SCHEMA" could not be bound. The multi-part identifier "CHECK_CONSTRAINTS.CONSTRAINT_NAME" could not...
