Some Notes, Some Scripts

These are the noted taken for searching solutions and some scripts to identify the problem

Categories:

In theory, DATABASE_OBJECT_CHANGE_GROUP would be enough to capture “Alter Table” and “Alter Procedures”. But in practice you’ll see that sql cannot capture these actions. So you must add SCHEMA_OBJECT_CHANGE_GROUP, too. Actually, the DATABASE_OBJECT_CHANGE_GROUP is auditing the ALTER permission […]

Categories:

You want to backup or restore a database but you cannot see the Drive letter even you had mapped fromo operating system. you should follow these steps: MAP YOUR DRIVE OPEN YOUR XP_CMDSHELL OPTION DEFINE YOUR MAPPED DRIVE […]