update TableA set MONBR = LEFT(B.SAP_VALUE, 7)

   from TableA A, TableB B

 where A.MONBR = B.MONBR

    and B.SAP_NAME = 'CFG_PRODORDERNBR'

Correction, Limit to eight active connection (not Five) at the same time.

select a.id, a.sysdate, b.id, b.sysdate, a.sysdate - b.sysdate as DiffDate

  from test1 as a

inner join (select top 100 percent id, sysdate from Test1 where id < (select count(id) from...

MSDE can only accept 5 concurrent connection at any point of time.

You have to recreate the table and that is how EM does.

Can you post the result of select @@version.

As someone mentioned, It is a bug of SQL Server and was fixed by hotfix 780. Call Microsoft to get the hotfix.

How do you define linked server? From EM --> Security --> Linked Server --> YourLinkedServer --> Tables will tell you the schema and catalog name if you are able to...

select identity(int,1,1) as row_number, * into #temptable from yourtable

select * from #temptable

drop table #temptable

http://www.sqlsecurity.com/DesktopDefault.aspx

Try to disconnect and connect again.

sp_who2

or

select * from master.dbo.sysprocesses

Depending on how much data can you afford to loss, You may run transaction log backup more frequetly.

Are you able to ping the linked server? You should start the network trace between both servers.

It is not SQL Server issue but problem with DHCP. Check DHCP configuration on both client and the DHCP server.

create procedure sp2000_sarboxaudit as

/****************************************************/

/* created by: sql profiler ...