Hi

You can view the information of all the users in SYSXLOGINS table in Master database

Thnks

hi

In this case,First u take backup of your database and then change the recovery model to simple

By which transaction log will not get save

After this you can delete the records...

NO

server and instance are not same

one server can have many instance

there are two types of instance

1)default instance

2)named instance

server can have only one default instance and 50 named instances

there is no point in using third party tool

every tool fires the same query and gives the result

better way is using activity monitor which gives exact result and flexible

u can...

alter column to identity is very easy in ms sql server 2005

just right click on column you want to alter and click on design and change identity...

this is really great