Hi Lutz,

below is my data

insert into testing1(date1) values('A15014248336 00008800VIS20100907100000');

A15014248336 00008800VIS20100907100000EUR0USD0000000000000100000000000000000000100000000000000000000100000000000000000000100000000000000000000000000020000000000000000000000000000000000020000000000000000000000000000000000026500000000000000000000026500000000000000000000000000000209

I copy your scripts is working fine...

HI Mike,

Thanks for your reply,

Last time is working fine, we are using blatmail external application to send a mail. but only this few days is having an error. everytime they...

HI All,

I have same problem found in SQL Error Log in SQL 2005, last time is running daily successfully but only this few days I received error. Anyone can help...

Hello,

I already fixed that error, now if i schedule 1 job in one time scheduled, I receive this error

"Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate...

Hi Sandy

can you enhance my query.

because i dont know what can i create a query.

Thank you

Hi Mulawa,

This code is from VB, so i cannot create temp table for this, can can you give me the script using in visual basic as well?

thanks

only 100 records, I want to trace some blocking error while im deleting, at the same time insert 1 record at a time. this one is running but some problem,...

Thank you the two of you, I get what I needed...

Hi Gail Shaw

Do you have a script to capture the blocking spid, show all the detail in a one whole grid, thanks

In returning to the issue, I want something to create an script, to see which is idle and lock, and log, can anyone give me the sample scripts, Im using...

The Database cause of blocking, can you give me an script to get the idle time,log and who's blocking of the sql. Its the idle time cause of cpu or...