Hi Ravi,

You have not mentioned the what version of SQL Server Installed on Instance1 and Instance2.

Could you please clarify them. also provide the Screenshot of your errors.

Hope you...

you are trying to update the LOCATION_TABLE columns into #temp_tables column. am i right.

if that is true you don't need to use the co-related sql statement on this cause.

you can...

i used to do this by creating batch file using sqlcmd and will schedule it in the windows scheduler

it is always to have the patches or hotfixes updated with our SQL Server .:) great to hear that your issuse is resolved:-)

yes this really good question

Yes i agree to it

Could you please attached the screen shot of the main and subplan screen shot as well job properties.

you can also configure the trace for deadlock which will give you victim and the query, or sp.

Note: run the profiler on the different machine as it is resource intensive...

Could you please elaborate what events you want to set. are you looking at the Profiler or performance counter.

if you could give the bit more explanation so that every...

For DBA

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

From the Windows Perspective, he needs to able to login to the SQL Server Remotely and Able to access the Server Without any problem and he need to control...

you can configure them by using an interface

open the SQL Server profiler > File > NeW Trace

it will ask you the Credential the server you want to trace...

there are lot of reason the database goes to suspond mode

data page corruption, Log file grows and do not have space on the disk,may your t-log got currputed.

please refer the following link

http://databases.about.com/od/sqlserver/a/bcp.htm

Hope this help.

if you have a problem locks then you can try to run this batch by batch such 1000,2000,3000,etc.

you can use the bcp utility to achive this.

quick steps to identify the isssues are

1. run sp_who2 check any blocked SPID are there or not.

2. find out what is the blocked SPID T-SQL .

3. need to check is...