archiveMay 2021

Limitations and Restrictions The remote access option only applies to servers that are added by using sp_addserver, and is included for backward compatibility. Permissions Execute permissions on sp_configure with no parameters or with only the first parameter are granted to all users by default. To execute sp_configure with both parameters...

A while back, I worked on a project that required persisting data to multiple databases. The requirement was to save some data to a Microsoft SQL Server (which hosted the billing application data) and save a different set of data to an Oracle database (which housed the database for the...