Hi Team,

Am using sql server 2008, also SSRS is installed in my server, i want to find the CPU and Mrmory Utilisation for Reporting services.

Find how much memory /CPU is...

hi,

Agree,

But as per my screen shot, % Processor time is not showing.

Thank u.

is there any query to get the same details...?

Hi Team,

Can u please tell me that the msg "UPDATE' is not recognized as an internal or external command,"

is coming from the SQL exec call or from the batch file??...

Hi Team,

Its not working...!

Hi,

370 MB.

is there any way to generate the .sql file.

Thank U sqlnaive

Hope it works.

Great...!

Thank u,

my requirement is when ever insert happens on main table then i want to execute Stored proc1,

if delete happens on main table then execute stored proc2,

if update then stored...

sorry,

bit communication GAP,

i want to call .java files in sql trigger....

Is it possible...?

I Agree,

But job will not work in my scenario,

i want only, when ever any event (insert/update/delete), then only i want to execute the java batch file,

Please help...

Thanks.

what ever i have, i given to you and asking for suggetion / help to come out from the error.

if u want detailed ddl's and trigger.

i'll complete the trigger after...

Hi,

Below is the query am using..

create or replace trigger tr_stud

after insert or update or delete

of stud_code , name

on stud

referencing old as old new as new

for each row

begin

...

Hi Team,

given code is not working, here am giving my scenario with details.

Table : Stud

---------------------------------------------------

Stud_Code| Name

View : CST

---------------------------------------------------

Stud_id|LIb_id

Table : LIB

---------------------------------------------------

Lib_id| Current_Date

Stud_Code column in "STUD" and stud_id column in "CST"...

Already checked the links. but not getting exact solution.

is there any syntax error in trigger any issues.

Please help me...

My requirement is when ever any insert|update|delete happens on Table1:Test,

then it should check the ID value in table SID, if ID is avaiale then update the column "status"...