I am trying to generate a schema using a SP written in a remote SQLSERVER ver 2000 (O/S Windows 2000). I get the following error message:
“failed to execute sql statement. Please ensure that the supplied syntax is correct. New transaction cannot enlist in the specified transaction coordinator”