i checked and the mail server is ok. Any other area where to look into.

Can someone help me out please??

I do not have any idea. its the stored procedure that causes this.

thanks again friend.

one question how can i see which table has clustered index?

ok now i see they are there thanks a lot for the script. appreciate it

ok so i used the SSMS way and changed the filegroup. but now i run the below query to see the index description, size etc and still in the index...

any idea friends?????????

thanks a lot.

as i mention earlier create one bcp job and because of that Tempdb grows. but now that job won't run so the Tempdb won't grow much. so any idea how...

so now i have moved the Tempdb to a new drive but its 200 GB now, so any idea to shrink it.

so after moving the tempdb files i still see my files in the old drive where it was before. and also see the files in the new drive so what...

i was looking forward to move the Tempdb to a new drive that has more space . so now after using the Alter statements and then moving the files, SQL...

so is it right that the very first step is to run upgrade advisor and then move on to the second step?

Please check i have made the corrections. if wrong let me know please-------------------------

USE ur_db_name

GO

SET NOCOUNT ON;

DECLARE @objectid int;

DECLARE @indexid int;

DECLARE @partitioncount bigint;

DECLARE @schemaname nvarchar(130);

DECLARE @objectname nvarchar(130);

DECLARE @indexname nvarchar(130);

DECLARE @partitionnum bigint;

DECLARE...