Problem with TMSChangeNotification component(1)

[MNosouhi]

when i use "select * from MyTable" in "SQl" peraperty of TMSQuery , TMSChangeNotification component raise a error with this message :"statemant does not support notification" ;
this only work correctly if use "select TId, TName, TDatein from dbo.MyTable" . that means i can not use "*" in sql statemant and must use "dbo." (the owner of table) befor of tablename.
how can i removed this limmits?

i use SDAC ver 4.35 and delphi7&Delphi2007 and windows xp with sql2005

[Challenger]

These are restrictions of SQL Server. There is no way to avoid them. For full list of limits please refer to
http://msdn2.microsoft.com/library/ms181122.aspx

[MNosouhi]

Thanks