If you’re trying to do an insert to a table where every column has a default value (or is an identity column), then SQL Server will give you an error if you don’t specify ‘something’ in the field list/values clause… Or so I thought…
This is so simple it’s funny, but not so simple to find in the documentation:
INSERT INTO TableName DEFAULT VALUES