Congratulations Jeff and Michael!!

you can write sql-dmo scripts embedded in vb/java script to collect all the information and write directly to excel. I dont knopw whether (3) can be achieved b TSQL or...

and make sure you disable the index first, then do the delete, and then enable the index. Make sure you have enough space for the transaction logs as well, otherwise,...

6 points for a non sense??? This was too much

Oops, my bad that I replied 🙁

This may be helpful - http://msdn.microsoft.com/en-us/library/ms190794.aspx

You can use xp_fixeddrives

where are you working currently? Tell us the reasons why you ask this question.

60 lakhs = 6 million 🙂

please go through this link - http://msdn.microsoft.com/en-us/library/ms190940.aspx

yes, I agree. I thought the missing values wont be continuous. And yes, recursive CTE is an answer.

select @@version

Restricting access is not something you should do on a fly. Do the following -

1. Decide and Write down the various access levels required by the various users/groups

2. Talk with...

try some form of this -

select a.id - 1 from table_name a where not exists( select b.id from table_name b where a.id = b.id + 1)

the first record will...

Can you please let us know why you require this?