I guess you're referring to the alert in the status line of management studio: "Query complete with errors"

For a very long insert script the Messages pane may be full of things like '(x row(s) affected)' - but you will just have to scroll through to find the red error message. - There may be several.

You should post the exact error mssages.