Hi

Which option(s) did u use in your alter index statement.

Try doing a DBCC Indexdefrag or if u can do DBCC DBReindex. DBReindex can be done using REBUILD option in Alter...

Hi

Has there been any addition/modification/deletion of data ?

got that

thanks

Hi

Yes be default SQL sets the Pkey as a clustered index.

This need not necessarily be the best index for you.

Study how the data in the table will be used...

Hi

Use different tables and then enforce referential integrity.

Hi

See if this helps you.

declare @empskill VARCHAR(100)

set @empskill = ''

SELECT @empskill = @empskill + Skill level from table

where emp_id = 2541

select distinct emp_id,@empskill ...

Hi

If your table name is unique in a server you can use objectname filter.

you do have instead of triggers in sql 2000.

Hi

Could tell the problems you faced when you ,emtiom you failed to do this.

In SQL 2000 you can use partioned views to do partioning.

In SQL 2005 you can partion a...

Hi

can we do a attach db here ?

Hi

sys.dm_exec_sessions requires VIEW SERVER STATE permission on server.

Hi

What would be the size (approx) of the db that you plan to create daily ?

Hi

Peters script will work, but if you find it confusing try this. create a temp table or table data type and populate that with data that you want. Finally...

Hi

Stored procedures do have performance advantage over code written at client side. SP code resides in the server and is pre-compiled.

hi

You can do this with SSMS. Right click on the db and select Properties. In the Options tab set the Restrict access to SINGLE_USER.