hi,

first itz not a production database

2nd i hv proper back up

3rd look into my 3rd point in the previous post.

so @sql...

Hi All,

Thanks for your suggestions,

I've done with it. Steps I've followed are

1. KILL the processes which is active / suspended / sleeping etc on the database 😀

2. ...

obviously,

hundreds of database triggers cannot be created on single database.

but i was searhing the normal triggers in data base triggers txtPost_CommentEmoticon(':hehe:');

thnx,

regards

viji

hi,

i found........

if i create a trigger on database then it comes under database triggers........

or else

it comes under that particular table itself. 😀

columns........keys......constraints..........triggers

thanx

regards

viji

i'm using sql server 2005. for that also its not appearing........

wht to do.

but i've created a new trigger that is appearing. the others which is having type as TR...

hi suresh,

thanx for your quick reply.

my sys.triggers shows more than 100 triggers but my database triggers shows nothing.

if i query syscomments i can get the text of the triggers also....

Thanks Lynn Pettis,

that is a web application. I use sql server 2005 and ASP.

the same code works well with one set of DB. the same code doesnot work...

Hi,

i'm from data base background. so i don't knw much abt . net

but if u say that is the only solution, then i can take someone's help from my...

what you are telling is 100% true.

But my client wants to send an error message with only those records if it is not in proper dd/mm/yy format.

really held up.

-Viji

Thanx for your reply.

but my problem is if it is 14/05/09 it takes as 14th May 2009.

But if it is 04/15/09 then it takes 15th April 2009

but...

Hi Abhijit,

The trace gives me very lengthy reports if I query those to get eventclass in (12,13) would that be sufficient?

Again I have to get table names from Inline...

SELECT DISTINCT

o.name , oo.name

FROM sysdepends d, sysobjects o, sysobjects oo

WHERE o.id=d.id

and o.name= @ProcName -- Stored Procedure Name

and oo.id=d.depid and depnumber=1

ORDER BY o.name,oo.name

THIS WILL NOT...

Thanks for your valuable responses

Regards,

Viji

Hi Grant Fritchey,

Thanks for your reply. my problem is the profiler fetches many rows and filtering table names alone from it is a painful job. Instead I'm...

Hi,

i end up with Rajesh's idea. and it works well.

i have to try Gianluca Sartori's suggestion also.

thnx guys,

regards,

viji