SSC-EWI-TS0079

Database console command is not supported

Severity

Medium

Description

This EWI is added when SnowConvert finds a DBCC statement inside the input code. Most DBCC statements are not supported in Snowflake.

Code Example

Input Code:

IN -> SqlServer_01.sql
DBCC CHECKIDENT(@a, RESEED, @b) WITH NO_INFOMSGS

Output Code:

OUT -> SqlServer_01.sql
!!!RESOLVE EWI!!! /*** SSC-EWI-TS0079 - DATABASE CONSOLE COMMAND 'CHECKIDENT' IS NOT SUPPORTED. ***/!!!
DBCC CHECKIDENT(@a, RESEED, @b) WITH NO_INFOMSGS;

Recommendations

Last updated