Hi

Below are the clarification for you..

First off, does the database have any free space? If not then why shrink?

Yes. We have created and dropped the large(30GB) table.

Do you really...

ok..

but what is the role of partition in data loading and deleting the data.

what is data loading and removing. can you explain me.

Hi

I got the things about view. But what about the tempdb details. How can i identify whether the tempdb is full or not?

Hi Dev,

Here actual problem is procedure is not yet executed. it is waiting for response from the server to execute. As per your point...

Hi Sujeet,

As per your point before executing any procedure or sql statement it has to get the response...

I had set timeout as 30000 in vb.net code

Hi Elliott Whitlow,

It is not executing to me. is it executing to you?

Hi,

Either through front end or back end query anything is enough.. Please send to me

Regards,

Vaithilingam.K

Hi Ashish,

Thanks a lot

Hi,

One more doubt. Is it possible to use user defined variable as a seed in identity function. Becuase i have three insert query in my procedure. I...

you mean to say once i populate data on #tmp2 table by using your query ,then i will have to move #tmp2 to tbl2(My tmp table). After that i can...

One more thing is i am using sql 2000 not 2005. row_number() function will be available in 2005 only.

am i correct?