I am trying to convert a SQL server database to go from a test bed site to our live environment however the versions are not compatible. I have tried to generate a script but keep receiving an error even as an SA user at the same location:
Property TextHeader is not available for StoredProcedure '[ACOCMP1].[add_hiredest]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted. (Microsoft.SqlServer.Smo)
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.