I agree with you both...but TempDB is in shared environment ...I cant control everything there ...I can check my functions and SPs (I have already optimized SPs for this) but...

sometimes because of memory issue otherwise space issue.

Thanks,

Sanjeev.

And It worked for me ...

Thanks Colleen M. Morrow for guiding me to the correct article ...

Thanks,

Sanjeev.

My sincere apologizes for not writing back the reason why I want to know.

I have a custom application which is in clustered/shared environment. My client complaining that since the TempDB...

Thanks buddy ...for spending time on this ...appreciate this.

Thanks,

Sanjeev.

Thanks Paul,

I logged in using SA account and created a temp table and ran the query on TempDB ....result as expected. And my expressions were :smooooth:

BUT then I logged in...

Hi -

Not sure if you have got the answer to your query.

Enterprise Manager can generate a script for all the objects in the database (right click the database, "All...

Thanks for your time.

Here you go, this is what i am doing :

SQL server >> Database >> Tasks >> Export Data >> Choose a data source >> Choose a destination...

Thanks a lot to all of you..!!!

For sparing your precious time and sharing your knowledge...I would definitely keep these points in my mind and will change the maintenane plan accordingly....

Hi -

Its just a simple maintenance plan where I am rebuilding indexes, reorganizing indexes, shrink database...etc. All the usual stuff. Secondly, I am not sure but in past I...

sure,

I will keep it in mind next time.... I was not aware of this sp.

Hello All -

Thanks for your time on this. What I have done is that I attached the MDF file only and then rename the LDF file (need to stop the...

Hi -

Following are the answers to your questions:

1. the definition of the temp table #TCodeTemp.

= create table #TCodeTemp

(

[User] Nvarchar(250) COLLATE database_default , ...

My apologizes for not being clear in my comments.. We can very well avoid the cursor.

Thanks,

Sanjeev.

Hi -

I have modified the suggested solution a bit....now I am not using #table.....But it has solved my problem.

Thanks a lot for your efforts and time on this. I...