Out of the box ..once proper permissions granted .. receive this error for every table (below)
Not certain what settings can be changed on my side or if anyone has encountered the same?
You are more than likely running into an error caused by a version of SQL Server earlier than 2008.
See https://stackoverflow.com/questions/27060586/cannot-assign-a-default-value-to-a-local-variable-in-sql for reference.If this is the case, please refer to https://www.idera.com/productssolutions/freetools/sql-data-profiler/systemrequirements for technical requirements for this product.
Powered by IDERA