Sql-Server-Query-World

Fix the Retention days for Each PublicationStep 1: Check for the publication properties subscription expiration setup. If it is set to "never expire" as you can see from the screen capture below. Step 2:Change the retention days to 120 hours and

Read More

HelloFirst point that you need to keep in mind before you insert any null value in a SQL Server Table column is that you need to make the column to accept nulls by default which can be mentioned while creation

Read More

DDL (Data Definition Language): DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the

Read More