Thanks for the inputs.  Beside LogExplorer, there is no way to inform dba the object get dropped?  All I need is to know the object get dropped so that I...

You can run a query from system table and send you an email with attachment:

SELECT * FROM msdb.dbo.sysjobs A, msdb.dbo.sysjobservers B WHERE A.job_id = B.job_id AND B.last_run_outcome = 0

and enabled...

Sorry for not being clear enough. 

Yes the table is huge meant there is about 2 millions records. However, it product will have 5 product choices is the most. And...

Thanks for the input.  However, the table is huge, I can not pass the product_choice one by one like your. 

I think of some kind of cursor needed, but I...

Can you try something like this.  It works for me when I saved the file as .dts, I don't know it will work for .bas or not.:

DECLARE @TARGETDIR varchar(1000)

SET  @TARGETDIR...

Will this one work for you?

select convert(varchar(10), getdate(),101)

Minh Vu

thanks very much.  I worked for me.

Minh Vu

thanks much.  I found that one too.

Minh

Will dts be able to handle restoring log files as well?

Minh Vu

No special reason at all, since I get used to isnull and convert function already.

Thanks,

Minh

thank you so much for all of the help.  Based on Carl's input, I used self-join to work it out and it worked for me.  All I did is adding...

yes, it does have.

Something just weird with sqlserver.  I fixed it by creating a new db from another sqlserver, copying the mdf files over and attaching it.  After that, everything came back normally. ...

sqllog said: 'Starting up database testdb'

windowlog had no error message.

The weird thing is I couln't create the testdb, but why sql log said 'starting update database testdb'

Thanks

Minh Vu

I know that there are several issues with the application designs; however, I had a hard time to persuade the developers.  I captured a lot of embeded sql statement that...