To enable a cache dependency on a particular database, run this command in from a command-line prompt: This creates a new table, AspNet_SqlCacheTablesForChangeNotification, in the designated database. Next, several AspNet_SqlCacheXxxx stored procs are created...
Cursor allows us to perform line-by-line operations within the returned values in SQL Server. We make this structure, which we use frequently in programming languages, thanks to the cursor in the database. We can...
Actually, this code has several purposes. It gives Identity information only when the table name is given. When ‘reseed‘ is added, if the table has a problem with identity, it helps to fix it,...