// Create a SqlNotificationRequest object.
SqlNotificationRequest notficationRequest = new SqlNotificationRequest();
// Associate the notification request with the command.
__cmd.Notification = notficationRequest;
But I get an error saying I need SQL 9 or later, aldo SQL 2005 Express says it΄s version 9
Personally, I would rewrite the C# code to parse each line of each script and execute a SqlCommand object for each line that starts with insert, update, delete and maybe select. If they are transactional statements, in each script then this will be a little bit harder but should be do-able.