Get sql server objects list

In PL/SQL we can user ‘User_Objects’ to retrieve list of al the objects.

In SQL Server this can be achieved by using ‘sys.Objects’. This provides a high level view of all the objects which can be used for retrieving various type of information.


SELECT * FROM  sys.objects




Below queries can be used to extract a specific type of object details.

SELECT * FROM  sys.Procedures


 SELECT * FROM  sys.tables


 SELECT * FROM  sys.views

Create S#arp Architecture solution using Templify

S#arp Architecture is really get very handy when you do not want to spend time on creating all the required components in your .Net projects.

S#arp Architecture - Architectural foundation for ASP.NET MVC    Templify - making solution creation simple.

You can have complete details on sharp architecture here.

In earlier release , S#arp Architecture template was available for Visual Studio(not for 2010). But this gets more and more easy as Templify is available. In addition install T4 Toolbox  also .

If you have installed Templify and T4 Toolbox   than you are ready to roll..


So lets Templify…

1. Create folder on the location you want to create your project.

2. Right click on it and click on “Templify Here


3. You get a small window .


4. Select Sharp Architecture template from the dropdown and provide your new project name .

5. Deploy Template .This extract files from the template package.


6. Now a complete solution is to work for you



More References:

Generic Permission/Security Model

permission Model
permission Model
In most of the application , we need permission model.
Here is a simple generic model where action level permissions can be handled easily .
The database design is self explainatory . But ofcourse let me know if someone need more help on it .
Suggestions are more welcomed to add improvements in this approach.
Take care .

Error:”Saving changes is not permitted” on SQL Server 2008

I was using sql server 2008 first time . I have created my database table in it and loked fine . Aftrer two days I needed to add some columns and change some of the properties in the tables I have already created . As usual I have done the changes and click on save table button…


I get an error message “Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created

Possible reasons for this error :

  • You change the Allow Nullssetting for a column.
  • You reorder columns in the table.
  • You change the column data type.
  • You add a new column

(Refernce from MSDN)


After analyzing I have found a fix for it :

  1. Open SQL Server Management Studio (SSMS).
  2. On the Tools menu, click Options.
  3. In the navigation pane of the Options window, click Designers.
  4. Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

Note : In general you should keep this checkbox  checked . Alter changes via script.


Team Foundation Server 2010 details

I was in TFS2010 (team Foundation Sever 2010) seminar yesterday.The seminar was presented by 2 people from Microsoft, Germany I am looking for the best software development/management practices these days, so it was quite interesting for me . Till now I have seen SCRUM and RUP (Rational Unified Process). I am sharing few thing about TFS 2010 today .

What is Team Foundation server ?

Team Foundation Server is basically a collaboration tool for aligning more or less all the possible component/modules in a software development process. It automate and streamlines the software delivery process for all the team members . TFS is crafted in such a way , it can be even used by single person team, small team or globally scattered many small or large teams .TFS concentrates on putting the basic software development practices into the habit of a developer and it also covers the SCRUM practice. TFS has incorporated the SCRUM template also in this release.

Well what i like most is that now manager need not to ask their developers for the project status and developer need not to actually wait to get his/her tasks from someone. Project owner /manager can generate various kinds of reports and track the progress of the project in real time .So TFS is one stop shop for software developer and project managers both.

What was before ?

Till now , whenever we had any project we basically had these component considered :

  • Code Repository
  • Build Process
  • Task Allocations
  • Reports
  • Project management
  • Bug Tracking/Issue management
  • Knowledge repository
  • Test repository


Well we have to take care all of the above separately and its needless to mention the complexity and risk in it .

How TFS makes difference ?

TFS make all these separate component talk to each other. It works on a Process Repository component. TFS has a possibility to extend it further and interestingly it supports Eclipse now..I do not about you , but i was surprised by it ..:)

New Application Lifecycle Model (ALM) in TFS )

How it works ?

Microsoft has used some terminology in TFS to make it generic for all the process/projects. Out of many other artifacts there is one important artifact called “Work Items”. Its has “User Story” , which more or less a module and this has some Task under it . One task may had more User stories and those can have some another tasks.

So Task and user Story comes under Project implementation section .

MS has done a really nice job for the testing of the project Now you can really perform your testing very easily and later you can automatize is too.You can create bug in TFS directly whenever any test case fails and the testing is recorded in a Video (this is probably new in testing )

Various Reports

Testing Features (embedded in VS2010)

  • Playback action recordings and run coded UI Tests for Silver light 4 applications.
  • Edit coded UI tests using a graphical editor
  • Use action recordings to fast forward through manual tests that need to support Mozilla Firefox 3.5 and 3.6.
  • Run coded UI tests for web applications using Mozilla Firefox 3.5 and 3.6
  • Code visualization and modeling features
  • Use the Generate Code command to generate skeleton code from elements on UML class diagrams. You can use the default transformations, or you can write custom transformations to translate UML types into code.
  • Create UML class diagrams from existing code.
  • Explore the organization and relationships in C, C++, and ASP.NET projects by generating dependency graphs.
  • Import elements from UML sequence diagrams, class diagrams, and use case diagrams as XMI 2.1 files that are exported from other modeling tools.
  • Create links and view links from work items to model elements.
  • Create layer diagrams from C or C++ code and validate dependencies.
  • Write code to modify layer diagrams and to validate code against layer diagrams.

Integration ???

TFS directly talk with MS Office 2007/10 . Needless to mention that it has integration with share point too.

VS2010 Work flows

TFS 2010 Branching foundation Acrhitecture

Automation platform Support

Referrence :