Hi

Once u take the activity monitor on the top of the screen u can see a "Filter" option. Take that and u get the "Filter settings" screen. Under Resource\Blocking type...

Or u can use the Generate scripts to script out all the users and logins.

Yes u can use activity monitor. There are filters that can be used to see blocking/blocked transactions.

Hi

do nightly backups take only the differential backups. So u have only one differential backup a day ?

Log backup and Differential backup strategies are best decided by the amount...

Hi

Give us the exact details that you want and then we can try.

Will each student will have his own database or will all students have a single common database.

have u...

Hi

Sorry for the delay in reply.

U will have to create a separate login for each student. Then in the students respective database u can create the database user corresponding to...

Lots and lots of articles on the web.....

Hi

You will have to catch the error and insert into the table after the transaction is rolled back. you can do this from the application (after roll back) .

If Rowversioning is used read operations will not take Shared locks on the data and hence will not block other operations.

How ever you will be able to read the last...

Hi

select object_name(object_id),* from sys.columns where

name = 'OfferExternalID' -- put the column here.

you can use the Convert function for formatting the date.

Hi

What exactly is the error that you get?

Have u actually created the login and the user. The user must be created in the database that you are trying to connect....

Hi Jeff

I have a doubt abt the index selection when i ran your code

in the article ' Running total.......'

I created the table dbo.JBMTest , added the clustered index...

Rob

Thanks for the info. Yes rewriting the query to use the same index will be a good idea. Keep us posted.

Hi

You can script the 8 column table and then insert the data from the two tables. By scripting the table atleast you get the primary key, indexes of the 8...

Hi

Have you updated the statistics and space usage. These need to be done after migration.