few questions about MSDE...

what are pseudo tables
how queries run by MSDE
how stored procedures run in backend by MSDE
how triggers run by MSDE
where triggers and stored proc stored in MSDE and in which form
where logs are being maintained of transactions/DML statement by default

MSDE has been replaced with SQL Server 2005 Express.

For answers to your questions, as well as a source for tutorials, refer to Books Online.

SQL Server 2005 Express
http://msdn2.microsoft.com/en-us/sql/aa336346.aspx

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx
http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F

SQL Server 2005 Express Video Learning
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#1

|||pls if u don't know the answer then don't reply any post ... and thanks for googling for me|||

Some times it is not bad approach to provide the link which answers all your qurestions. Arnie posted all the MSDN URLs, you need not google it. If you read these MSDN you will get answer for all your questions.

|||here we come to get answers.. ofcourse after going thru whole book every1 will get answer and if we have to go thru books then there is no point to come on such platforms. i put that question on two forums and this person asked me on other forum that i shouldn't post here .. i feel convinient to put on different so i could have early and better response. i don't think so any1 should mind on that atleast.
i went on these links but .. anyhow here i don't think so other should ask what to do and what not.. and if there is some question of any1 then that person shouldn't be forwarded to books atleast he can tell me chapter anyhow thanks m disappointed|||

Muhammad,

You have to understand that this forum is simply a medium, most often an unnecessary medium, where you'll find many patterns in responses. For example, the higher the posting count the reponder has, the more likely they will reply with links.

I share an equal frustration with you on not receiving a direct response here. I have found only 1 use for these forums and that is to post actual code, when I encounter a problem, simply for a second or third set of eyes. Outside of that, you'll find no real experts here and you'll discover that this forum has developed into an automated link service.

Just my twist on it,

Adamus

|||no man actually i don't agree with you. here i got answers most of the time and correct and to the point information. all fingers are not same. every person has his/her own approach. its very good platform. i m just waiting for answer here, not references or comments or advises .. i hope you got my point

i still say thanks to that person who try to answer my question but in fact i don't like stupid advises or comments.

i didnt mean to hurt any1. sorry if anything of mine hurt any1.