Hi Chandu,

I think you have not paid any attention to my earlier reponse to you ( dated 01/06 on this topic...

1. Login to Query Analyzer as sa.

2. Change the DB name where you need to shrink the files.

3. Take a good backup of your DB and the transaction Log first....

On UNIX, you can execute a program in the background ( & at the end OR nohup ). This means the trigger ( xp_cmdshell ) gets a signal that the...

Thanks for your help. This is a round about procedure but I think this is the only to do in SQL Server. In Oracle, it is quite simple.

--Chandra

If you do not care about the log data, do the steps in this order

1) "backup log" with truncate_only.

2) Then Shrink the log

An example below.

This will bring...

Thanks a lot for your help, Simon. It works in a Stored procedure but not in a trigger. So I created a new S.P with the INSERT and xp_cmdshell commands....

Dear Simon,

I have an After insert trigger on a table and I execute a JAVA class file as below.

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

select @my_cmd='D:\j2re\bin\java.exe -classpath "'+'D:\MSSQL7\JOBS\sub_key." gensubkey ' > D:\MSSQL\JOBS\sub_key\qry1.txt'

EXEC @key_result=master..xp_cmdshell @my_cmd

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

...

Hi Prakash,

I have a different problem. I have a AFTER insert trigger on a table. In the trigger, I would

like to read...

You can generate a serial OR sequence number in a SELECT statement using the IDENTITY function ( do not mistake it with the table property: INDENTITY although similar functionality ).

The...