Give more info... So that we can tell a solution.

We are using two tier architecture. We are connecting SQL server from App server using COM+ applications. Any problem in this?

How to check it???? Can elaborate on it????

Why u want to change the default size and autogrow of the tempdb????

Thks gail.

Hi Arun,

It works in all SQl versions.... SQL injection is not allowed.... let me try and post reply for your scenario.....!!

Hi ,

Compile the attached SP ,pass your view name as the parameter and execute. Hope it will work.

Revert in case of any issue.

I guess some condition is getting failed in ur trigger.So the no of rows effectd is "0" .

You should not get "Text" in ur sp_helptext body of the view!! am i rite??? Is this u really looking for??? need more info??

My server is Win 2008 Standard edition 64- bit. Iam not getting any memory issues. But still i want to increase the performance. All the database are frequently used ,...

Markus,

We do all activities in administrator login. So i dint get this issue. Any way thks.

Hi ,

Stop all the services related to SQL. Eg: SQL server,Agent,Analysis,Integration etc.

Got to Command promt.

Type as :

Step 1 : net stop mssqlserver

Step 2 : net start mssqlserver /f /T3608...

I have a RAM of 32 GB. We are maintaining around 80 databases. But the priority is for only 3 databases. I want all the pages in RAM for those...

Hi ,

Try to use tablock in delete Statement. it may work.:w00t: