Stored Proc in TempDB

[eramgarden]

Ok, this is my 3rd day on this new job and this is what my manager just said to me:

 

" the companty we do business with has a lot of stored procedures etc in tempdb AND DO A LOT OF THINGS THAT ARE NOT CONSIDERED GOOD PRACTICE. We are kind of stuck in that, I read up and from my reading CLUSTER for primary key is always a good idea and there are no downsides. As soon as I did that, the app quite working".

 

What should my response be?? Who puts stored procs in TempDB? What are the side effects down the road? If ONE client is doing that..should I suggest that we leave that client alone but for the rest, we need to change the schema??

 

any advice would be great.

[eramgarden]

Never Mind.