April 16, 2010 at 3:40 am
HI, I want to Create a application just like the sqlserver client access. By using SMO object in .Net we can create that. But I don't have much idea about that.Right Now i am in the middle of the application i.e now i can connect with the sever and can get all the databases from that server and also got the tables with structure almost like Enterprise Manager. But now i want to create a query analyzer, Is it possible to create that using SMO object.. Please give me some idea.........
April 16, 2010 at 1:14 pm
If by "query analyzer" you mean a gui interface that allows you to type in, save, retrieve, edit a query then submit it for execution and show back result set ... yes, sure you can.
Any particular reason to reinvent the wheel?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply