Hi.
>SQL Server is just really good product.

I know this. Mys sister is a professional developer and worked with many backends, but, when asked what she likes more, the answer is "SQL Server".

But it costs.
I remember that some times ago, a company wanted to sell to us an integrated system package (accounting, sales, etc) based on it + WEB interface. After a long discussion (they avoided price details), finally told us the price for just accounting and fixed assets module + 5 CALs , 16000 Euro. Was too much. I don't know how much was because of SQL Server price.

>Hi Dorin !
>Debugging of SQLServer stored procedures is possible in VS.NET (from enterpise developer version).

So the guy lied, or didn't knew this.

>User defined function can be created very easily on database level using T-SQL.

Yes, but how good is execution speed? (I remember some threads about data processing - or munging? - being slow)

>As regards as capability.
>MSDE is more similar to Firebird.

What I like more at Firebird is, besides usual features, its automatic crash recovery, online backup, shadows for databases, multiversioning (for each transaction is generated a record version-that's why it can recover automatically to last known good state) and the fact that modifying metadata doesn't mean records conversions at that time, but when the record is "visited". Also there is no TGL or limit for connections/queries.
There is a lot to talk about,about both MSDE or Firebird, but this thread is about something else :-)

>SQLServer is something different - it is not only database engine it is also great documentation, great powerfull tools (profiler, query analizer, agent, data transformation services), COM automation interface, XML interface, reporting services and ease of use all of the mentioned tools. I am not from MS marketing - SQL Server is just really good product.
>
>
>>Yes. C++ and Delphi developers have native components to acces Interbase and Firebird databases. They don't need ODBC or OLE DB drivers. There are IBO, IBX, FIBPlus, DBExpres. Also a very well documented API, but samples are all in C,C++ or Delphi. Also, if one need custom UDFs, these can be written in C, C++ or Delphi and then registered into database. Also stored procedures debugging is possible, with break points, watch variables, steb by step execution (BTW, it is true that is not possible something like that in SQL Server?).
>>Makes me wonder, if a small server like this has so many features, what SQL Server, Oracle or DB2 are capable of doing?
>>