Skip to main content


Showing posts from May, 2012

Re-engineering with SSMS

Dear Friends, Last week I was doing Database Re-Engineering of our few Legacy Applications.
Actually Re-engineering is a set of activities that are carried out to re-structure a Legacy System to a new system with better functionalities and conform to the hardware and software quality constraint.
I tested 3 Tools for Data-Modeling for this process.
(1) Toad Data Modeler 4.1 (2) Microsoft Visio and (3) SSMS 2008 .

Data Modeling is a process used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations. All are the good software for Data-modeling but I liked all time favorite SQL Server Management Studio Relationship Diagrams simple-easy, free and having good options..

A little formatting in SSMS database diagrams editor
As more tables will be added, these may not be arranged for easy viewing. To change the arrangement of the diagrams you can right click in the database diagram editor or use the Datab…

Enabling and disabling logins in SQL Server 2005

In SQL Server, much like other services with users, login accounts can be enabled or disabled. An enabled login can be authenticated and allowed access to database resources. A disabled login is not allowed to establish a connection to the SQL Server instance.
For example, let's create a login called sumank. CREATE LOGIN sumank WITH PASSWORD = 'ipl5@2012' ,DEFAULT_DATABASE = AdventureWorksUSE AdventureWorks; CREATEUSER sumankIn the first statement, the sumank login was created with a fairly complex password and a default database of AdventureWorks. Afterward, we switch to the AdventureWorks database and create a new user for the database. If we attempt to login to SQL Server using these credentials, we can. Next let's disable the login with the following statement. ALTER LOGIN sumank DISABLEIf someone attempts to login to SQL Server using the sumank login, the connection attempt is rejected and Error 18470 is returned - "Login failed for user 'suma…