As a database designer, I often create on database tables the primary key as identity autoincrement and sometimes I needed to find missing or deleted IDs thet interrupt the sequence…
As a database designer, I often create on database tables the primary key as identity autoincrement and sometimes I needed to find missing or deleted IDs thet interrupt the sequence…
For different needs, often I had needs to send a list of values to a Stored Procedure. To achieve this goal it is possible to use a workaround with the…
When you modify database schema on Sql Server with Microsoft SQL Server Management Studio you can simply create script with Generate Change Script function. This is not allowed when you…
If you drop a user that owns a schema, you'll receive the following error: Drop failed for User 'my_user'. (Microsoft.SqlServer.Smo) The database principal owns a schema in the database, and…
Visual Studio Team Edition for Database Professionals (VSDBPro) consente di gestire la definizione del vostro schema di database di SQL Server allo stesso modo di come gestite i vostri progetti…