No you cannot invoke a function on the client from the database using SQL Server features.
Why not do it the other way around? The client can poll the database periodically to see if there is data for that client. Another possibility is to use
SqlDependency[
^]