SELECT spid, kpid, blocked,DBID,DB_NAME(dbid) AS databasename,(SELECT TEXT FROM SYS.DM_EXEC_SQL_TEXT(SQL_HANDLE))SQLHANDLETEXT,

hostname,loginame,cpu,physical_io,memusage,login_time,

status,program_name,cmd,nt_domain,nt_username

FROM sys.sysprocesses

WHERE DB_NAME(dbid) = 'databasename'

from this query you will find which process...

hi i m agree with you but actually i have already compared sp through redgate....for my company's work....so i am not doing that type of practice through that waste my...

hi john you are right you think that why i m not using available software ...actually i have redgate....but want to know there in sql there is any way...

hi .....is that showing any error...or not....

the best way is that just generate script of that table and create that table into destination and then try to transfer only data....have...

my mail id is :- rajacharyaengg@gmail.com

you can mail me....but also put your questions here....bec more hands better then one......

you are welcome any time....we are here to help each other's difficulty

hi i think your requirement is like...for example you have schedule job for procedure and you want that each time when job executes it will ask users for parameter...

yeh man you need to create your own trigger for that.....i don't think so there is no specific mechanism for insertion and update ....but you can put trigger on table...

if you want to pass parameter into sql job ...first of job means...you must put facility that when sp executes it automatically take parameter from somewhere ...now another thing ....i...

hi as per lowell told you need to check your code first ..and another thing if your inserted records have you count are they same...as in source table...may be when...

no man this is not cause of application problem....this only what your transactional log file full and now there is not enough space...if you want to check then do some...

hi when you run sp_helpserver what is id of that server is it server

i think when we open that first time then that goes into cache...and second time it may be reuse that from cache...this is my simple thought...

hi rene thank you very much man....you are great...

i have done that change and what i have seen this is working....

but i have one question when we are doing import...

hi thanx for fast reply....

i have done changes and set that it to table or view... still same thing happening it's bypassing trigger